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 >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
