Dang.
that means I might actually have to tell them we can do it :)
Rachel
- "Deshpande, Kirti" <kirti.deshpande_at_verizon.com> wrote:
> 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:ktoepke_at_trilegiant.com]
> > 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: 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: Toepke, Kevin M
> > INET: ktoepke_at_trilegiant.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).
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).
Received on Wed Jul 17 2002 - 15:41:18 CDT