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.
```

Computer Science & Information Technology

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.

Computer Science & Information Technology

How do you add more photos or videos to a slide show?

What will be an ideal response?

Computer Science & Information Technology