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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie - SQL

Re: Newbie - SQL

From: stinky <stinky_at_stunk.org>
Date: Mon, 01 Apr 2002 20:04:03 -0500
Message-ID: <3CA90383.488024CB@stunk.org>


Isn't that syntax actually part of the ANSI standard? It's been around in several database engines for quite a while. I was surprised to learn that Oracle only began recognizing it in version 9i.

damorgan wrote:

> What you did wrong was try to take your knowledge, likely based on a
> Microsoft product, and assume you could blindly apply it to Oracle: You
> can not. The Microsoft syntax has been added with version 9i but is not
> present in 8i or before.
>
> You will also likely find that you will make huge messes if you make
> assumptions based on how other products do things and apply them to
> Oracle. Oracle's transaction, locking, and multiversioning are
> completely different and greatly affect what you write, when you write
> it, and how things work. I strongly urge you to get a good book on
> Oracle and not rely on your previous experience except as a starting
> point.
>
> Daniel Morgan
>
> Addison Schildt wrote:
>
> > Learning with Oracle 8i (UNIX). The SQL below gives
> >
> > ORA-00933: SQL command not properly ended
> >
> > SELECT Table1.*, Table2.*
> > FROM Table1 INNER JOIN Table2 ON Table1.ID = TABLE2.ID;
> >
> > What have I done wrong? Thanks in advance.
Received on Mon Apr 01 2002 - 19:04:03 CST

Original text of this message

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