1-WHAT IS DIFF BETWEEN VARRAY AND TABLE?2-WHAT IS SQL SUPPORT FOR NESTED TABLE?3-WHAT IS INLINE STORAGE AND OUT OF LINE STOGARE OF THE NESTED TABLE?4-WHAT ARE COMMON EXCEPTION RELATED WITH COLLECTION?5-CAN U DECLARE VARRAY OF VARRAY OF VARRAY OF TABLE?6-GIVE SAMPLE DEFINATION OF VARRAY OF OBJECT AND TABLE OF OBJECT?7-WHAT ARE COMMON METHODS OF HANDLING EXCEPTIONS?

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 ----------------------------------------------------------...

basukolur014

 Profile Answers by basukolur014 Questions by basukolur014

• Feb 28th, 2011

Exceptions related to collections are...1.collection_is_null2.collection subscript beyond count3.collection subscript outside limit4.no_data_found .these are more common exceptions  related to collections.

Answer Question  Select Best Answer

1-WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?2-WHAT IS THE USE OF UROWID?3-WHAT ARE THE SUBTYPES?GIVE ANY 2 EXAMPLE?4- WHAT IS THE GENERAL STANDARD FOR DECLARATION?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Dec 27th, 2010

1... max length is 327672 rowid means row plus id actuall its psedocolmn that store the value of each rowwith the help of rowid>>>  we can remove duplicate value>>> we can dispa...

muraligrandhi

 Profile Answers by muraligrandhi Questions by muraligrandhi

• Nov 9th, 2010

1. Maximum length of a varible in PL/SQL is 32767 bytes2. The UROWID or Universal Rowid is useful for storing logical addresses of all the rows of Index-organized tables. It can store both the logical...

Answer Question  Select Best Answer