OraFAQ Forum: SQL & PL/SQL » Collection of colletion in pre-9.2 DB

Home » SQL & PL/SQL » SQL & PL/SQL » Collection of colletion in pre-9.2 DB

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

Collection of colletion in pre-9.2 DB [message #2281]

Wed, 03 July 2002 10:09

Vincent Chao
Messages: 1
Registered: July 2002

Junior Member

Hi,

Is there any workaround we can use to implement collection of collection (TABLE of TABLE, or hashtable of vector) in pre-9.2 DB?

--
Thanks,
Vincent

Report message to a moderator

Re: Collection of colletion in pre-9.2 DB [message #2352 is a reply to message #2281]

Mon, 08 July 2002 22:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I have thought about that too, some time back.

In fact, I've found one solution. It involves 'fooling' the compiler with the usage of forward declaration. I'll look for it, because it is from some time back now.

But SF has a more simple solution to this one. Look here:
http://www.quest-pipelines.com/pipelines/plsql/archives.htm#writings04
Look for the 'Two-dimensional arrays'

I guess the easiest way is the SF way, but I'll let you know if I come up with sth.

HTH,
MHE

Report message to a moderator

Previous Topic:	obtaining the database layout??
Next Topic:	SQL to Concat colmn values of Diff records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 30 19:28:49 CDT 2025