no, I do have SOME input -- we'll be hiring a consultant DBA on this, at least to get it up and running. I have some control over who we hire. I'm going to make sure I get someone who is willing and able to say NO.
And I refuse to mention the "ANY" datatype :) Rachel --- Connor McDonald <[EMAIL PROTECTED]> wrote: > "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 > === message truncated === __________________________________________________ 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).