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

Habib Ali

• May 10th, 2016

PRAGMA is instruction to compiler
AUTONOMOUS TRANSACTION means running an SQL transaction inside a PLSQL block of code independently i.e Making changes to DB regardless of other transactions & their locks/latches

sujata

• Jan 19th, 2016

Pragma AUTONOMOUS_TRANSACTION instructs the compiler to treat the PL/SQL block following the pragma as autonomous (independent) from the calling transaction. Pragma can be applied on:- 1) Anonymous PL...

Answer Question  Select Best Answer

1. What are the different types of joins?2. Explain normalization with examples.3. What cursor type do you use to retrieve multiple recordsets?4. State the difference between a "where" clause and a "having" clause5. What is the difference between "procedure" and "function"?6. How will you copy the structure of a table without copying the data?7. How to find out the...

rr

• Apr 19th, 2017

Full OUTER also...is nothing but combination of Left and Right Outer Joins

vishal bansal

• Jul 28th, 2016

This answer is incomplete... we have in total 6 types of joins from Oracle 10g onwards

Cross joins
Inner joins
Outer joins
Equi and non-equi joins
Self joins
Partitioned joins

Answer Question  Select Best Answer