Re: INNER JOIN

> Barry Young wrote:
>
> I am using Access to create a SQL query. It creates an Inner Join
> Query. I cut and paste the query into PL-SQL. When I try to execute
> the query I get an error.
>
> ORA 933 SQL command not properly ended.
>
> It highlights the INNER JOIN statement on the SQL command.
>
> Can someone recommend a utility to convert these Microsoft or Access
> SQL queries to PL SQL?
>
> Thanks!
>

Please post your SQL statement, and the target Oracle version. If it's proper SQL it should run on plain Oracle (since Oracle runs as close to the standard as any) but the version number is certainly a big help.

Ana C. Dent suggested adding a line with a slash "/" as the only thing on the line. No leading or trailing charaters (not even a blank). Something like

SELECT * FROM TAB
/

or

SELECT TNAME
  FROM TAB
/

Please note, PL/SQL is Oracle's procedural programming language (doing roughly the same as Sybase's Transact-SQL (AKA Microsoft's T-SQL)). These languages try to put procedural stuff (sequential statements, loops, conditions, etc) around SQL. I suspect you are trying to use plain SQL rather than the slightly more complex PL/SQL.

HTH
/Hans Received on Sun Dec 28 2003 - 04:05:50 CET