This content has been marked as final. Show 2 replies
Explain what you need with other words.
By SQL:1999 do you mean ANSI? the first and the third queries you listed were ANSI using the ANSI join syntax. The second query used the traditional method of performing the join in the WHERE clause using the Oracle-specific "(+)" to indicate an outer join.
Do you merely want to have 2 versions of each SQL, ANSI and not ANSI? Simply recode the query to use the other join syntax if that is the case.
Welcome to the forum!
I'm pretty sure that, by "SQL:1999" the instructions mean ANSI notation (that is, using the keywords JOIN and ON in the FROM clause), and by "traditional" they mean the older notation, where the FROM clause only contains a comma-separated list of table names (perhaps with aliases), and all the join conditions are in the WHERE clause. As Riedelme said, Queries 1) and 3) as you posted them are already written the "SQL:1999" way, and 2) is already the "traditional" way.
Be careful to follow all the instructions, including those about upper- (ABC...) and lower-case (abc ...) letters.
It looks like this assignment is based on the hr.employees table that Oracle provides for exercises like this. Note that not every employee in that table has a manager, similar to the way that not every employee has a department.
This question concerns the SQL language, not the SQL*Plus front end. In the future, you'll get better response if you post questions like this on the SQL and PL/SQL Forum:
PL/SQL and SQL
The same account you created to post this question will work for either forum.