DISQUS

DISQUS Hello! Eddie Awad’s Blog is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Eddie Awad’s Blog

News, views, tips and tricks on Oracle and other fun stuff
Jump to original thread »
Author

NVL2 in Oracle

Started by Eddie Awad · 7 months ago

Did you know that in addition to the function NVL, Oracle also has the function NVL2? which is quite different than its cousin NVL. So, what does NVL2 do?

Syntax:

NVL2 (expr1, expr2, expr3)

Purpose:

If expr1 is not null, NVL2 returns expr2. If expr1 is null% ... Continue reading »

3 comments

Add New Comment

Returning? Login