Skip to content

Instantly share code, notes, and snippets.

@maartenl

maartenl/nvl_to_coalesce.sql

Created February 7, 2013 05:54
Show Gist options
  • Save maartenl/4728868 to your computer and use it in GitHub Desktop.
Save maartenl/4728868 to your computer and use it in GitHub Desktop.
Download ZIP
Transformation from NVL to COALESCE
Raw
nvl_to_coalesce.sql
-- provides an employees mobile phonenumber or his/her
-- regular phonenumber if he/she doesn't have one
nvl(empl.mobile_phonenumber, empl.phonenumber)
-- changed to
coalesce(empl.mobile_phonenumber, empl.phonenumber)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment