PL/SQL [message #600055] |
Thu, 31 October 2013 05:15 |
|
aravindreddy.akiti
Messages: 14 Registered: October 2013 Location: hyderabad
|
Junior Member |
|
|
why we use VARRAY,NESTED TABLES,INDEX BY TABLES in plsql.
please give me a answer.......!
|
|
|
|
|
Re: PL/SQL [message #600096 is a reply to message #600055] |
Thu, 31 October 2013 14:25 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
aravindreddy.akiti wrote on Thu, 31 October 2013 15:45why we use VARRAY,NESTED TABLES,INDEX BY TABLES in plsql.
please give me a answer.......!
Because scalars and collections are different. You CANNOT store multiple values in a variable declared as scalar data type. These are different options provided to you per your requirement. Each of them will work in the way they are defined for specific purpose. Go through docs for more clarification on collections.
In addition to the links provided by @ramoradba, you could have a look at the data types, which are well documented, to understand how scalar datatypes and non-scalar(collections) work : http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/datatypes.htm
Regards,
Lalit
[Updated on: Thu, 06 March 2014 13:37] by Moderator Report message to a moderator
|
|
|