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

What are the basic sql commands?

1095

---

What is 19 null in sql?

973

---

What are the different datatypes available in PL/SQL?

1088

---

What is mdf ldf and ndf?

1002

---

What is sequence in sql?

1027

---

How do I view tables in mysql?

986

---

Can we use insert statement in function?

1004

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2085

---

Is grant a ddl statement?

901

---

Can we use having without group by in sql?

986

---

What is a loop in sql?

989

---

Which are the different case manipulation functions in sql?

1027

---

What is rowid in sql?

991

---

What is pl sql record in oracle?

1037

---

Why do you partition data?

1026

---