"database indepdent"...
oh dear...You're doomed :-)
- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> and here they want to be "database independent"
>
>
> sigh. it's for a content management system
>
> --- "Toepke, Kevin M" <ktoepke_at_trilegiant.com>
> 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" <ktoepke_at_trilegiant.com>
> > 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: 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).
> >
> > --
> > 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).
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: hamcdc_at_yahoo.co.uk
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 Thu Jul 18 2002 - 06:18:25 CDT
