PL/SQL-Collections help

From: <jairamk_at_geocities.com>
Date: Thu, 18 Mar 1999 19:05:22 GMT
Message-ID: <7cripc$317$1@nnrp1.dejanews.com>

Hi!
I am working with PL/SQL release 8.0.4.0.0 and i am in need of using a user defined record type with similar properties as a struct with union in C/C++.

Basically i need to define a record structure like

record (columnname varchar2, columnvalue uniontype) where uniontype would be a union of a varchar2 and a date value.

to make a long story short i need to be able to use a nested table where each record has a columnname and a columnvalue and the columnvalue could either be a varchar2 value or a date value.

Is this possible... if yes, then any help would be appreciated

Thanks in advance
Jairam Kuppuswamy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 18 1999 - 13:05:22 CST