Tuesday, June 22, 2010

Oracle quiz

Rewrite the following IF statements so that you do not use the IF statement to set the value of no_revenue. What is the difference between the two statements?

IF total_sales <= 0 THEN
   no_revenue := TRUE;
ELSE
   no_revenue := FALSE;
END IF;

Answer:
no_revenue := NVL (total_sales, 1) <= 0;
Highlight to find out the answer.

No comments:

Post a Comment

Oracle Query