DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ANSI std not supported

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all, the query

    select count(*) from TABLE1 A LEFT OUTER JOIN TABLE2 b
    on a.ID1 = b.ID2;

    is the ANSI SQL standard for outer join - why do I get a
    ERROR at line 1:
    ORA-00933: SQL command not properly ended

    Do I have to install any specific ANSI support for Oracle ?
    (Like that for English query support on SQL Server)

    I am using Oracle 8.1.6 on Solaris.

    Thanks,
    Shiva.

    [Edited by rshivagami on 03-28-2002 at 11:49 AM]

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In Oracle 8.1.6 ANSI standards for OUTER/INNER JOIN in "from" doesn't work.

  3. #3
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    If it is not supported, then do I have any work around here - I want to write one single query which is compatible with both Oracle & SQL Server databases.

    Thanks,
    Shiva.

  4. #4
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Where can I find any document on the list of ANSI SQL command formats supported by Oracle 8i ? I searched for it in technet.oracle.com, but found it only for 9i..

    Shiva.

  5. #5
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Is UNION clause the only way out for outer joins?

    Shiva.

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You can use the (+) operator for outer join in 8i:

    select count(*) from TABLE1 a, TABLE2 b
    where a.ID1 = b.ID2(+);

    Oracle 9i supports the ANSI standard n this regard.




    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width