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

Where is pl sql used?

951

---

what is the difference between a having clause and a where clause? : Sql dba

1087

---

How do you update f as m and m as f from the below table testtable?

1858

---

How to install oracle sql developer?

1042

---

Can you have more than one key in a database?

937

---

which tcp/ip port does sql server run on? : Sql dba

1026

---

What is trigger types of trigger?

1068

---

Write a unique difference between a function and a stored procedure.

995

---

How to assign sql query results to pl sql variables?

1078

---

What does varchar include?

947

---

What is sql basics?

1041

---

How to fix oracle error ora-00942: table or view does not exist

1012

---

What is pl/sql table? Why it is used?

1036

---

Is pl sql different from sql?

996

---

what is sql server agent? : Sql dba

1102

---