Community Page
- awads.net/wp/ Jump to website »
-
Subscribe -
Community
-
Top Commenters
-
Popular Threads
-
Recent Comments
- wow this suxxxxxxxxxxx
- My husband works in China. When I visited I met some lovely Chinese people. One young man went out of his way to show us China. Wonderful shopping experiences & friendship. My husband is...
- Thanks very much for sharing that Eddie, it saved me a lot of time! Best regards, -Adam vonNieda
- Hi William, I'm assuming you're referring to the usefulness of Enso or other launcher applications. I have Firefox open all the time so it does not make much difference there. From personal...
- To open Firefox, wouldn't it be simpler to click on the Firefox icon? Or in Windows, press Win-R to get a "Run" prompt and type "firefox"? Google and Dictionary.com already...
Eddie Awad’s Blog
News, views, tips and tricks on Oracle and other fun stuff
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 »
Syntax:
NVL2 (expr1, expr2, expr3)
Purpose:
If expr1 is not null, NVL2 returns expr2. If expr1 is null% ... Continue reading »
4 years ago
DECODE(COMM, NULL, 'SAL', 'SAL & COMM')
http://thinkoracle.blogspot.com/2005/06/decode....
But, keep in mind that NVL and NVL2 seem to have a performance hit over the more verbose manual NULL check.
http://thinkoracle.blogspot.com/2005/06/nulls-i...
orig article:
http://www.oracledba.co.uk/tips/plsql\_nvl\_cos...
discussion:
http://www.phpbbserver.com/phpbb/viewtopic.php?...
Cheers,
Robert
4 years ago
Thanks for the extra tips and links. I see you are a fan of Tom Kyte. I am too. I have learnt a lot from him, and still learning...
Cheers!
2 years ago
heheh no loves for PL/SQL I guess
http://groups.google.com/group/comp.databases.oracle.server/msg/165d24ffccb982e7?dmode=source&hl=en