SQL specifies two different syntactical ways to express joins i.e. "explicit join notation" and "implicit join notation"
Old sql queries uses "implicit join" or you can say implicit syntax, latest sql uses explicit join.
now a days "implicit join notation" or implicit join are outdated as they are hard to understand in comparison to explicit joins/explicit join notation.
Now "explicit join notation" are use in new sql coding. They are easy to understand as they use JOIN,LEFT JOIN,RIGHT JOIN notations.
So does this mean it does not matter at all? to use new or old sql?
The issue is new instructors uses new sql syntax, which will confuse you when you are assign to check sql reports codes in EBS which are written in old syntax.
yes it don't matter which syntax you use.
new sql syntax is easy to understand.
with little bit of practice you can understand old syntax as well.
it just dont use words saying what joint it is ,some practice will make you at ease with the old syntax as well.
finally its up to your ease with the which syntax you feel comfortable and use.
hope you have got satisfactory answer.
What is the counter part in new sql syntax for the following?
SELECT * FROM EMP E, DEPT D where d.dep_id(+)=e.dep_id(+)?
Thanks Bashar for that excellent docs. I really admire Oracle-Base
Does it have Database Administration I & II documentation?