Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL (SQL DEVELOPER)
PL/SQL [message #600055] Thu, 31 October 2013 05:15 Go to next message
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 #600058 is a reply to message #600055] Thu, 31 October 2013 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because we need it.

Re: PL/SQL [message #600059 is a reply to message #600055] Thu, 31 October 2013 05:47 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.oracle-base.com/articles/8i/collections-8i.php
http://www.orafaq.com/wiki/VARRAY
http://www.orafaq.com/wiki/NESTED_TABLE
http://www.tutorialspoint.com/plsql/plsql_collections.htm


http://docs.oracle.com/cd/B10500_01/appdev.920/a96624/05_colls.htm


Sriram Sanka
Re: PL/SQL [message #600096 is a reply to message #600055] Thu, 31 October 2013 14:25 Go to previous message
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:45
why 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

Previous Topic: XML Variables
Next Topic: LONG data type obsolete - but Oracle use them in meta data (directory)? WTF?
Goto Forum:
  


Current Time: Thu Mar 28 15:44:23 CDT 2024