DATABASE PROGRAMMING

CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) ); CREATE TABLE emp( empno NUMBER(4,0), ename VARCHAR2(10), job VARCHAR2(9), mgr NUMBER(4,0), hiredate DATE, sal NUMBER(7,2), comm NUMBER(7,2), deptno NUMBER(2,0),

Use table of Employees for this question.

In an anonymous PL/SQL block, define a nested table, called Email_list, that Nested table

will use employees emails as its elements. Define a variable for this type.

1. Use the email addresses of those employees in the department (ID) 30 and 60 to populate this nested table.
2. Print out the contents of the nested table after having finished the population.
3. Display the value of limit of nested table.
4. Display the value of the last index.
5. Add one elements to the end this nested table, the new email value is GWASHINGTON,
6. Display the last element just added,
7. Delete the elements 2 and 3,
8. Display the current size (count) of this variable,
9. Display the value of the last index,
10. Print out the existing elements of the nested table.

*** END of the file. ***