Create a sequence deptid_seq to generate department Id (in dept table) and another sequence empid_seq to generate employee Id (in the employee table). Use deptid_seq to add a new department in the dept table. Now, add yourself as a new employee with empid_seq in the department you just added.

Question

Use case study databases for the following queries.

Answer 1

```
SQL> CREATE SEQUENCE DEPTID_SEQ
2 START WITH 55
3 INCREMENT BY 10
4 MAXVALUE 95
5 NOCACHE;

SEQUENCE CREATED.

SQL> CREATE SEQUENCE EMPID_SEQ
2 START WITH 600
3 MAXVALUE 999
4 NOCACHE;

SEQUENCE CREATED.

SQL> INSERT INTO DEPT
2 VALUES (DEPTID_SEQ.NEXTVAL, 'PROJECTS', 'MONROE', 111);

1 ROW CREATED.

SQL> INSERT INTO EMPLOYEE
2 VALUES (EMPID_SEQ.NEXTVAL, 'SHAH', 'NILESH', 2, 111,
3 '13-JAN-04', 110000, 5000, DEPTID_SEQ.CURRVAL, 1);

1 ROW CREATED.
```