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
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
Comment