Answer Posted / subrat ray

Nested tables hold an arbitrary number of elements. They use sequential numbers as subscripts.
You can define equivalent SQL types,allowing nested tables to be stored in database tables and manipulated through SQL.
->it does not have fixed upper bound.
->the data storage is out of line.

DECLARE
TYPE COURSELIST IS TABLE OF VARCHAR2(10);
COURSES COURSELIST;
BEGIN
COURSES:=COURSELIST('A','B','C','D','E','F','G','H','I');
DBMS_OUTPUT.PUT_LINE('THE TOTAL NO OF ELEMENTS ARE:'||COURSES.COUNT);
COURSES.DELETE(1,5);
DBMS_OUTPUT.PUT_LINE('THE NO OF ELEMENTS ARE PRESENT IS:'||COURSES.COUNT);
END;
SQL> /
THE TOTAL NO OF ELEMENTS ARE:9
THE NO OF ELEMENTS ARE PRESENT IS:4

Is pl sql still used?

971

---

How many indexes can be created on a table in sql?

1043

---

what are the join types in tsql? : Transact sql

1060

---

What is the difference between having clause and where clause?

1057

---

Is sql a microsoft product?

944

---

What problem one might face while writing log information to a data-base table in pl/sql?

1152

---

Does oracle use sql?

924

---

Why join is faster than subquery?

1104

---

Why do you partition data?

1016

---

How many types of normalization are there?

955

---

What is execute immediate?

1078

---

Why is sql*loader direct path so fast?

1099

---

Can a trigger call a stored procedure?

1064

---

What are different clauses used in sql?

1112

---

What do you understand by pl/sql records?

1011

---