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" <ORACLE-L_at_fatcity.com> 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 <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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.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).