Re: Newbie - SQL

stinky wrote:

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

A good rule of thumb is that if it is present in DB2 then it is probably part of the ISO/ANSI standard. The rule doesn't always work, but is does most of the time. Received on Mon Apr 01 2002 - 21:36:09 CST