"database indepdent"... oh dear...You're doomed :-)
--- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > and here they want to be "database independent" > > > sigh. it's for a content management system > > --- "Toepke, Kevin M" <[EMAIL PROTECTED]> > wrote: > > I agree, it looks messy and confusing... However, > I found an example > > that > > makes it a little easier to understand. > > > > > http://asktom.oracle.com/pls/ask/f?p=4950:8:1062923::NO::F4950_P8_DISPLAYID, > > F4950_P8_CRITERIA:3099475696866,%7Banydata%7D > > > > My guess it was implemented for 2 reasons > > 1) to say they have every feature as M$ > > 2) to support 3rd party vendors porting stuff > from M$ > > > > Kevin > > > > -----Original Message----- > > Sent: Wednesday, July 17, 2002 1:35 PM > > To: Toepke, Kevin M; Multiple recipients of list > ORACLE-L > > > > > > Kevin, > > > > Looks messy to me, and damned confusing to > boot. > > > > Dick Goulet > > > > "The more you overtake the pluming the easier it > is to stop up the > > drain." > > > > Scotty of Star Trek, Search for Spock. > > > > ____________________Reply > Separator____________________ > > Author: "Toepke; Kevin M" <[EMAIL PROTECTED]> > > Date: 7/17/2002 9:58 AM > > > > 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/to > > c.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: 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). ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).