Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Know 1 database, know them all?

Re: Know 1 database, know them all?

From: Markus Reger <reger_at_mdw.ac.at>
Date: Sun, 16 Feb 2003 05:33:56 -0800
Message-ID: <F001.0054ED92.20030216053356@fatcity.com>


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).



Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
-- 
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US