basukolur014

 Profile Answers by basukolur014 Questions by basukolur014

• Oct 26th, 2010

 

Main diff between nested table and varray are..
1. Varrays have maximum size but nested table do not have maximum size
2.
Nested tables always dense, but varrays sparse. Elements of nested table can be deleted but varrays cant be deleted.
3.
Varrays stored in database in same table space but nested table data store out of database line in
separate table space.
4. Varrays data in database store as unique consecutive
subscripts but nested table not.

basukolur014

 Profile Answers by basukolur014 Questions by basukolur014

• Feb 28th, 2011

 

diff between nested table and varrays.

1.varrays will have max size but nested table do not have.

2.varrays stored in database in same table space but nested table in diff table space.

3.varrays are always dense but nested table can be sparse . we cant delete indisual elments of varrays.

4.varrays stored in database maintain there ordering and subscripts.

basukolur014

 Profile Answers by basukolur014 Questions by basukolur014

• Feb 28th, 2011

 

exceptions related to collections are...

1.collection_is_null

2.collection subscript beyond count

3.collection subscript outside limit

4.no_data_found .

these are more common exceptions  related to collections.

subhashishchaki

 Profile Answers by subhashishchaki Questions by subhashishchaki

• Oct 7th, 2013

 

Collections similarities and differences

Collection Type Elements Limit Subscript Type Uninitialized Status Always Dense
-----------------------------------------------------------------------------------------------------------------------------------
Associative array Unlimited String or Integer Empty NO
Nested table Unlimited Integer NULL NO
VARRAY Fixed Integer NULL YES

Defining and Declaring Collections

Code
-- Associative Array (index by integer)


 


TYPE sno_at IS TABLE OF NUMBER


INDEX BY PLS_INTEGER;


v_sno sno_at;


 


-- Associative Array (index by string)


 


TYPE marks_at IS TABLE OF NUMBER


INDEX BY VARCHAR2(100);


v_marks marks_at;


 


-- Nested Table 


 


TYPE fruits_nt IS TABLE OF VARCHAR2; 


v_fruits fruits_nt;


 


--VARRAY


 


TYPE fruits_vt IS VARRAY(10) OF


NUMBER;


v_fruits fruits_vt;