Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Know 1 database, know them all?
hello
general guideline
the SQL language is (almost) the same standardized one everywhere. BUT not everything is always implemented yet everywhere.
e.g.:
storing binary objects, stored procedures, java vm, sql*plus,storing java procedures (obfuscated or not) ...
e.g.:
conceptual differences creating an instance in ORACLE - even in sql terms - is pretty much heavier than in MySQL or PostgreSQL.
e.g.
ORACLE has a lot , MySQL is poorer. administer them both.
BUT: regarding to CODD'S rules if you need sql and nothing but sql - these sql machines should ofer you more or less the same. implies
...
and
the little differences sometimes drive you mad
BUT: understanding one like ORACLE gives you an oversight over many.I DO know, ORACLE isn't too easy;-)
Apologies for any typing mistakes I failed to notice.
Markus Reger
Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
>>> ddoralist_at_hotmail.com 02/16/03 05:59 AM >>>
Must have been basic theory or perhaps they were referring to ANSI SQL which
we all use.
You will find substantial differences between UDB, DB2/MVS, Oracle and SQL Server and all the others. I have worked at one time or another with the above mentioned and moving from one to another was fairly easy as a developer but for a DBA it was more complicated due to architecture differences in implementation.
Of course, maybe I am just a slow learner.
btw This guy was he the same one that said in a couple of years programmers won't be needed anymore or perhaps that 640K is all that you will ever need.
David Davis
Manulife Financial
>From: "Les Ayudo" <info_at_lesayudo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Know 1 database, know them all?
>Date: Sat, 15 Feb 2003 17:38:38 -0800
>
>I overheard one guy mention that once you learn one database, you know them
>all. Is this true? Or was he just talking about the theory behind the db?
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Les Ayudo
> INET: info_at_lesayudo.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net -- Author: david davis INET: ddoralist_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Markus Reger INET: reger_at_mdw.ac.at Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Sun Feb 16 2003 - 07:33:56 CST