RE: ANSI Joins

  • From: "Orr, Steve" <sorr@xxxxxxxxxxxx>
  • To: <mgogala@xxxxxxxxxxxxxxxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 18 Jan 2005 12:06:18 -0700

With me it's a matter of what I learned first then being the old dog
having to learn new tricks. We have MySQL/Oracle going on here and I've
been known to complain loud and long about MySQL's non-ANSI SQL
compliance so you can imagine my past disgust when MySQL was compliant
on this one and Oracle was not.

SELECT proficiency FROM dba
WHERE new_tricks =3D old_dog(+)

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala
Sent: Tuesday, January 18, 2005 11:45 AM
To: 'Oracle-L (E-mail)'
Subject: ANSI Joins=20

My developers are starting to use ANSI joins in vain hope that they will

make their apps portable
across databases. I have a positive attitude toward ANSI joins: I hate=20
those verbose extensions
that make SQL statements lengthy and unreadable. What is the opinion of=20
other people about ANSI joins?
What is the @#$%! allure of those things? Where did they learn it from?=20
Is there any readable document
that explains  ANSI joins for dummies?

Mladen Gogala
Oracle DBA
Ext. 121



Other related posts: