Home » SQL & PL/SQL » SQL & PL/SQL » Index by clause in collections
Index by clause in collections [message #293459] Sun, 13 January 2008 01:26 Go to next message
agrawalpramil
Messages: 3
Registered: January 2008
Junior Member
What is the difference in usages of plsql table in below blocks....
What I know nested table is the one without "index by" clause but used as database object.

I am confused, block2 collection will be nested table or plsql table here?

<< Block 1 >>
SQL> declare
2 type test_pk_typ is table of varchar2(100) index by binary_integer;
3 begin
4 null;
5 end;
6 /

PL/SQL procedure successfully completed.

<< Block 2 >>
SQL> declare
2 type test_pk_typ is table of varchar2(100); -- nested or plsql table ?
3 begin
4 null;
5 end;
6 /

PL/SQL procedure successfully completed.
Re: Index by clause in collections [message #293462 is a reply to message #293459] Sun, 13 January 2008 01:33 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Chapter 5 Using PL/SQL Collections and Records
Section What are PL/SQL Collections and Records?
Subsection Understanding PL/SQL Collections

Regards
Michel

Previous Topic: Compare Null Value
Next Topic: Check Duplicate Row in a Table
Goto Forum:
  


Current Time: Fri Dec 02 20:57:50 CST 2016

Total time taken to generate the page: 0.09288 seconds