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

Thread: ANSI SQL in ORacle 8i

  1. #1
    Join Date
    May 2003
    Posts
    5

    ANSI SQL in ORacle 8i

    Hi,

    i am using the ANSI SQls in oracle 9i and working fine.
    Now i am using the Oracle 8i Ansi SQl are giving errors.
    Thee is any solution for that workable Ansi sqls in oracle 8i
    eg: ANSI SQL
    SELECT Customers.CustomerId, Company, OrderID
    FROM Customers C LEFT OUTER JOIN Orders O
    ON (C.CustomerID = O.CustomerID)

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Oracle 9i only support ANSI SQL, not 8i.

    The 2 statements below... 1st is ANSI SQL, 2nd is Oracle 8i. Now, make changes as necessary in your query.

    Code:
    SELECT e.last_name,d.department_name
    FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
    
    SELECT e.last_name,d.department_name
    FROM employees e, departments d
    WHERE e.department_id = d.department_id(+);
    Reference:
    http://www.oracle-base.com/Articles/...SQLSupport.asp


    HTH.

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