8i | 9i | 10g | 11g | 12c | 13c | 18c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for ANSI ISO SQL Support In Oracle 9i


Prakash Reddy APPIDI said...

The information about joins is simple and crystal clear and in comparison as well.

Shah G said...

Hello,
Nice and helping article,
God bless you for this free help
Shah G

Ayman A. Tuffaha said...

Really it's useful, and rich page ...

Jim J said...

God has given you the gift to share the knowledge. Continue the good work. He will reward you.

Sivu said...

Well described with examples...

Thanks a lot Tim

Syed Farhan Ashraf said...

Good Effort. Excellent for beginner.

ketan said...

it's so good & short way

ddg said...

Thanks, good information.
You should include that NULLIF(x,y) returns x if x does not equal y.

dean said...

Good article, but there is no CASE statement in SQL, it is a CASE expression

Tim... said...

Dean: True. I must have had my PL/SQL head on when I wrote that article. I've corrected it now. :)

Cheers

Tim...

Ramesh said...

Shouldn't the RIGHTOUTER join be like WHERE e.department_id(+) = d.department_id instead?

Tim... said...

Hi.

The (+) indicates the side that could be missing so these are both the same.

WHERE e.department_id(+) = d.department_id
WHERE d.department_id = e.department_id(+)

Remember, with the non-ANSI style join there is no concept of left or right or table order. It's just the side with the (+) that matters.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.