471,337 Members | 1,132 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

checking null values

In a table i have to check each and every column for null values . if the column has null value i need to display as ' NULL VALUE' in the output , for these iam declaring some local variables
Iam checking the column for null value using IF ( col_name IS NULL)
if the column has null value ill assign the variable as null value or else ill assign the value which is there in the column

another thing we can use NVL2 function to do the same

my doubt is perfomance wise which will be better to use
Aug 20 '07 #1
1 1983
8,127 Expert 4TB
Use the function NVL or NVL2 because these are predefined and definately execute in least time.
Aug 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

30 posts views Thread by Michael B Allen | last post: by
99 posts views Thread by Mikhail Teterin | last post: by
9 posts views Thread by D. Shane Fowlkes | last post: by
3 posts views Thread by Martyn Fewtrell | last post: by
8 posts views Thread by Fuzzydave | last post: by
2 posts views Thread by misty | last post: by
42 posts views Thread by =?Utf-8?B?UGxheWE=?= | last post: by
7 posts views Thread by nospam | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.