Re: RE: a couple of questions
I haven't been following this thread, but I saw the phrase "database independent" and couldn't help chiming in... For the past couple years, whenever someone mentioned "database independence" as justification for certain decisions, I suggest that they stick with MySQL and save themselves the licensing costs of Oracle. If you wish to program to the lowest common denominator and ignore all the features that have been bought and paid for, then have the courage to go all the way... Second argument is more fun: I like to challenge them that we'll be throwing out their newly-written "database independent" application code long before we change database vendors. After all, Java has only been around for a couple years; it stands to reason that it might just as easily disappear as quickly as it appeared, rather than persist. "That C# stuff is looking pretty cool; better get some training!" The intent is not really to tweak their tail (well, just a little!) and start an argument (but that's fun too), but to shake them out of their self-centric, auto-justified way of thinking... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 18, 2002 7:08 AM > 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 basi
RE: RE: a couple of questions
Rachel, I have talked to some very talented SQL Server DBA's that have used sql_variant data types. They all agreed that this data type is not worth the time. They would get unexplainable results. It is not so much a database issue but rather it is a coding and understanding of the data problem. In short, they said use standard data types. They also said it caused problems when they had to move data between various database platforms. Dave -Original Message- Sent: Wednesday, July 17, 2002 2:01 PM To: Multiple recipients of list ORACLE-L 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 R
RE: RE: a couple of questions
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, Kevi
RE: RE: a couple of questions
"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
RE: RE: a couple of questions
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 messag
RE: RE: a couple of questions
Some times I get a thin CD pack which only has 32bit. I will have to ask Oracle to ship me the 64bit version. -Original Message- Sent: Wednesday, July 17, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Dennis, I'm not sure your referring to the message I posted a couple of weeks ago, but the labeling on the CD's from Oracle can be deceiving. Each CD pack ships with both the 32 and 64 bit versions of Oracle, one of which is labeled with the bit value). Make sure you've got the right one. If memory is serving correctly 'variant' in MicroSlop maps somewhat to raw in Oracle. Dick Goulet Reply Separator Author: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 7/17/2002 9:33 AM Rachel - We are using 64-bit Oracle on 64-bit Solaris. No problems so far, but not much mileage on either. The one thing that came up is that you must be careful because you seem to get 32-bit Oracle by default. Someone on this list suggested running "file oracle". Oracle does have user-defined data types if that helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 17, 2002 12: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: DENNIS WILLIAMS 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: 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: Ji, Richard 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).
RE: RE: a couple of questions
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).
