Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: a couple of questions

RE: a couple of questions

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Wed, 17 Jul 2002 09:58:31 -0800
Message-ID: <F001.0049A4F1.20020717095831@fatcity.com>


A variant data type column in the database? What would be the domain of such a column? Does such a column not beg for data which should be placed in other columns to be stored in it? Oh what fun when someone stores 1234 or worse 1.2E4 both as a number and string.

Perhaps I'm to staid in my ways to grasp the benefits of its use in the database. It's use runs counter to the data modeling principles I was taught.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_SLAC.Stanford.edu

-----Original Message-----
Sent: Wednesday, July 17, 2002 10:09 AM
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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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: MacGregor, Ian A.
  INET: ian_at_SLAC.Stanford.EDU
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: ListGuru_at_fatcity.com (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). Received on Wed Jul 17 2002 - 12:58:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US