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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
