Nested and Normal Table

What is the difference between Nested Table and Normal Table?

Questions by jagadeesh9   answers by jagadeesh9

Showing Answers 1 - 3 of 3 Answers

garvi.1983

  • Mar 5th, 2008
 

Normal Table : It contain rows and columns.Each Row-Column represente only one value i.e intersection of Row-Column

create table t1(col1 number(10), col2 varchar2(9));------>Creates normal table

Nested Table : It contains some Row-Column as another Table. It can created by usin Objects,Collection.Refer collections
type r1 is recor(col1 number(10), col2 varchar2(9));------>Creates a RECORD
create table t2 (col1 number(9), col2 r1);------------------->Create a NESTED table--table inside another table

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions