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 <hamcdc_at_yahoo.co.uk> wrote:
> "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
>
=== 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: 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 Thu Jul 18 2002 - 08:08:20 CDT
