OraFAQ Forum: SQL & PL/SQL » Nested table or Object table

Home » SQL & PL/SQL » SQL & PL/SQL » Nested table or Object table (oracle database 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Nested table or Object table [message #598603]

Wed, 16 October 2013 00:25

njnbat
Messages: 19
Registered: September 2013

Junior Member

Hi , i would like to know how the below type is referred to in oracle pl sql

create type type1 as object
(
a number,
b varchar2(100)
);

I believe above one is known as object.

create type unknown1 as table of type1;

what is unknown1 called in oracle plsql .. Is it nested table or object table or object collection or array ?

Report message to a moderator

Re: Nested table or Object table [message #598604 is a reply to message #598603]

Wed, 16 October 2013 00:41

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Immediate answers in the following free books:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Report message to a moderator

Re: Nested table or Object table [message #598605 is a reply to message #598604]

Wed, 16 October 2013 00:51

njnbat
Messages: 19
Registered: September 2013

Junior Member

Ok.. so it is nested table . am i right ?

Report message to a moderator

Re: Nested table or Object table [message #598612 is a reply to message #598605]

Wed, 16 October 2013 01:38

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Can you post a link in the documentation above that states this.

Report message to a moderator

Previous Topic:	PL/SQL
Next Topic:	Regular expression to find commits in all Oracle source

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:03:07 CDT 2024