What's wrong with the SQL Syntax below?

Hello:

I am using SQL Navigator version 5.1.0.655.

I tried the following syntax that executes under SQL Plus but doe not under SQL Navigator:

SELECT *
FROM CODE A
LEFT OUTER JOIN CODELIST B
ON A.Codelist_ID = B.Codelist_ID

It says “SQL Command not properly ended”

Thanks.

I’ve been trying to reproduce your issue, but not with any luck. I’ve seen similar issues before, though. Have you tried just adding a “;” to the end of the statement and retrying? If I remember correctly, that’s fixed the issue before…

I am unable to recreate the issue. The query executes without any problem. May I ask you a few questions:

  1. which version of Oracle database are you using? are you sure it’s the same database against which you ran the query from SQL*Plus?
  2. is this the only SQL code in the SQL Editor, or there’s something else?
  3. can you consistently reproduce the issue? if yes, please send us the exact steps;
  4. can you execute any other queries successfully, performing the same steps?

Thank you.

This syntax works fine for 9i and 10g in SQL Nav, but it doesn’t work for 8i.
BTW the new syntax for OUTER JOIN was introduced in Oracle 9i.

Message was edited by: akot