Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difference between join conditions using NVL and not using NVL

710790Jan 5 2010 — edited Jan 5 2010

Hi,

I have a join condition in one of the applications as follows.

NVL(RQ.out_mesg_id,0) = NVL(RS.out_mesg_id,0)

How is it different without using NVL function. What is the internal execution difference.

RQ.out_mesg_id = RS.out_mesg_id

Will there be any difference in Performance and also in the query output.

Regards,
Pabolu

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 2 2010

Added on Jan 5 2010

#general-database-discussions, #sql

12 comments

7,090 views