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

Write the command to remove all players named sachin from the players table.

1120

---

What are the advantages of indexing?

926

---

how to calculate expressions with sql statements? : Sql dba

979

---

What is rownum?

923

---

Can we create table inside stored procedure?

903

---

What is the use of procedures?

923

---

What is a file delimiter?

1011

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

964

---

What is the use of function "module procedure" in pl/sql?

1131

---

Which sorts rows in sql?

967

---

what is sub-query? : Transact sql

1038

---

What is dbo in sql?

918

---

What are literals in sql server?

1068

---

What are the types of keys?

926

---

What is the difference between partition and index?

921

---