Dang. that means I might actually have to tell them we can do it :)
Rachel --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > Rachel: > For a quick scoop on this sys.ANYDATA datatype, check current issue > of > Oracle Magazine (Jul/Aug). Tom Kyte's column has neat information on > the > AnyDATA. But using it in SQL queries ain't the prettiest thing. > > HTH, > > - Kirti > > > -----Original Message----- > > From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 17, 2002 12:59 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: a couple of questions > > > > Rachel > > > > Check out the SYS.ANY datatype in Oracle 9i (from the SQL > reference). Me > > thinks its what SQL server would call a variant data type. > > > > Follow this link for more info > > > http://download-east.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/ > > toc.htm > > > > Kevin > > -------- > > The "Any" types provide highly flexible modeling of procedure > parameters > > and > > table columns where the actual type is not known. These datatypes > let you > > dynamically encapsulate and access type descriptions, data > instances, and > > sets of data instances of any other SQL type. These types have OCI > and > > PL/SQL interfaces for construction and access. > > > > > > SYS.AnyData > > This type contains an instance of a given type, with data, plus a > > description of the type. AnyData can be used as a table column > datatype > > and > > lets you store heterogeneous values in a single column. The values > can be > > of > > SQL built-in types as well as user-defined types. > > > > > > -----Original Message----- > > Sent: Wednesday, July 17, 2002 1:09 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, I'm working on what feels like 30 new projects all at once > and I > > WILL be RTFM'ing as soon as I can get more than 5 minutes out of > > meetings but.... > > > > > > first: has anyone heard of any problems with 64-bit Oracle on a > > Solaris 64-bit OS? > > > > second (and this one confuses me a bit)... I've been asked if > Oracle9i > > supports a "variant" datatype -- they are not familiar with oracle > but > > are familiar with SQL Server and say that there is a datatype > called > > "variant" there where you can basically overload the column with > > whatever datatype you want (string, number, date) and the database > > knows what type of data it is storing within the column. They > referred > > me to C++ and Java, neither of which I know. > > > > Can anyone point in the right direction to start researching this? > > > > Thanks! > > > > Rachel > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Autos - Get free new car price quotes > > http://autos.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Toepke, Kevin M > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
