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.
Use case study databases for the following queries.
```
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.
```
You might also like to view...
Once a paragraph is selected, choosing the fill color red in the Shading tab of the Borders and Shading dialog box:
A) makes the paragraph text red. B) makes the paragraph border red. C) highlights the paragraph text in red. D) makes the page border red.
How do you add more photos or videos to a slide show?
What will be an ideal response?