On The Insider: Janet Jackson Cancels More Shows
2 Resources for

nvl2

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Mini-Tip #5: Coalesce()
I recently wrote about NVL2. A function much like NVL2 is coalesce. Coalesce is of the format COALESCE(expr1, expr2, exprN...)Coalesce returns the first non-null expression in the expression list.Coalesce is different from most SQL functions in that it allows a varying number of expressions.Coalesce is basically a...
Tags: COALESCE, NVL2
Blog posts 2006-08-30
Mini-Tip #2 - NVL2()
NVL2 is a neat little SQL function that I think is underused. It seems to me it could have a better name. Theformat is NVL2(expr1, expr2, expr3). What it does is if expr1 is NULL,it returns expr3. If expr1 is NOT NULL, it returns expr2.An IF statement to...
Tags: NVL2
Blog posts 2006-08-17
  • << Previous
  • page 1 of 1
  • Next >>

TechRepublic Power Checklist: Securing Windows XP
If you have just finished installing Windows XP and you think the work is done, you're wrong. Some of the most important steps to getting Windows XP u ...
Buy Now
Planning for Disaster Recovery
To prevent data loss and maintain business continuity in times of crisis, IT pros must make disaster planning a top priority. This guide will help you ...
Buy Now