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 is the purpose of the sql select top clause?

1200

---

what is difference between delete and truncate commands? : Sql dba

1165

---

What is row_number () in sql?

1021

---

What are sql queries used for?

1064

---

Can we create view in stored procedure?

1017

---

How would you pass hints to the sql processor?

1033

---

What is a pragma statement?

1330

---

explain the difference between bool, tinyint and bit. : Sql dba

1057

---

what is the difference between join and union? : Sql dba

1192

---

What is a schema? How is it useful in sql servers?

1174

---

Why stored procedures are faster than query?

1076

---

Mention what does the hierarchical profiler does?

1131

---

Can we rollback delete command?

1032

---

What normalization means?

1010

---

What is the purpose of a sql?

1032

---