Home » SQL & PL/SQL » SQL & PL/SQL » Difference between array and varray (oracle 9.2.0.3)
Difference between array and varray [message #403874] Tue, 19 May 2009 05:35 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
what is the difference between array and varray? when to use temporary table?
Re: Difference between array and varray [message #403876 is a reply to message #403874] Tue, 19 May 2009 05:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

In addition, the exactly same question(s) has been asked not so long ago. Was it you? Otherwise, search for the answers (you easly find in the links above).

Regards
Michel
Re: Difference between array and varray [message #403884 is a reply to message #403876] Tue, 19 May 2009 06:09 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
I asked for a glass of water and u thrown me to deep into the sea!!!! Surprised
Re: Difference between array and varray [message #403893 is a reply to message #403884] Tue, 19 May 2009 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I give a clue: Ctl-F + Collection
You have the answer for the first question.
Second one, same thing.

Regards
Michel
Re: Difference between array and varray [message #403894 is a reply to message #403893] Tue, 19 May 2009 07:05 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
I just wanted answer in a single line.
Thanks for the link. But...................Now, I am in the sea!!!!!!! Confused
Re: Difference between array and varray [message #403906 is a reply to message #403894] Tue, 19 May 2009 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you try to do what I said: control-F then search for "collection"?

Regards
Michel
Re: Difference between array and varray [message #403913 is a reply to message #403874] Tue, 19 May 2009 09:19 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>what is the difference between array and varray
varray - array = v
Previous Topic: calling type inside package
Next Topic: procedure executed successfully but no data stored in table (merged)
Goto Forum:
  


Current Time: Thu Dec 08 08:44:43 CST 2016

Total time taken to generate the page: 0.16279 seconds