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...

Anonymous said...

to avoid misleading information, kindly ask you to update LEFT and RIGHT OUTER JOINs non-ANSI examples by placing "(+)" in proper place, otherwise both looks the same. https://oracle-base.com/articles/9i/ansi-iso-sql-support

Tim... said...

Hi.

It is not misleading, and it is correct. In all cases (ROJ, LOJ and non-ANSI), the dept table is the one we are getting rows from and the emp table is the one that *might* have joining rows. I even say in the article table order is not relevant. This is why both examples have "e.department_id(+)".

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.