Re: Newbie - SQL

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