-
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)
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|