Re: Access to Oracle (via Visual Basic) - ORA-00934

From: marcus johanson <marcus_at_zodiac.com>
Date: 20 Apr 1999 14:52:57 GMT
Message-ID: <01be8b3d$7b51d8e0$ec1b1dac_at_ut9811251830>


asshole

Ed Prochak <prochae_at_diebold.com> schreef in artikel <7fi1o6$t493_at_news.diebold.com>...
>
> Kevin Munro wrote in message <7f5eo1$58a$1_at_newnews.global.net.uk>...
> >I've some SQL statements which someone has created in Access and I want
> them
> >to run in Oracle.
> >
> >The SQL statement is generated depending upon what criteria the user
> selects
> >on a visual basic form. I'm connecting to Oracle via ADO.
> >
> >Basically, the problem is that these SQL statements have INNER JOIN and
> >LEFTJOINS etc in them and Oracle doesn't like these - I get an error
> >ORA-00934. Even if I simplify the SQL statement to just one inner join
and
> >run it in SQL Plus I still get the error message, so I am assuming that
the
> >keywords INNER JOIN are not standard SQL?
>
> There is standard SQL and there is Standard sql. The official SQL
standard
> defines
> levels of complience to the standard. It turns out that Oracle's SQL
> conforms to the
> first level. The reasons may be mainly historical (Oracle's SQL must
> maintain
> backward compatibility while the standard moved ahead). INNER JOIN is a
> feature
> supported on the higher levels of the standard. So INNER JOIN is very
much
> standard. In this case, Microsoft supports a higher level of the
standard.
> They had to
> provide something better than Oracle 8^).
>
>
> >
> >I normally write my SQL joins using the WHERE clause, but I am checking
> >another developers code.
> >
> >How can these be converted into valid SQL statements in Oracle?
>
> manually is one way. I normally write them using WHERE also. But it's not
> too
> hard to translate it from INNER JOIN to WHERE syntax.
>
> >
> >PS. Does anyone know of a good Oracle resource?
>
> www.oracle.com??
>
> >
> >If replying, please reply to kmunro_at_absoft.co.uk. Many thanks in
advance.
> >
> >
> >
>
>
>
Received on Tue Apr 20 1999 - 16:52:57 CEST

Original text of this message