1.

State The First_defined Function With An Example?

Answer»
  • This function is similar to the function NVL() in Oracle database
  • It performs the FIRST values which are not null among other values AVAILABLE in the function and ASSIGNS to the variable

Example: A set of variables, say v1,v2,v3,v4,v5,v6 are assigned with NULL.
Another variable NUM is assigned with value 340 (num=340)
num = first_defined(NULL, v1,v2,v3,v4,v5,v6,NUM) 
The result of num is 340

Example: A set of variables, say v1,v2,v3,v4,v5,v6 are assigned with NULL.
Another variable num is assigned with value 340 (num=340)
num = first_defined(NULL, v1,v2,v3,v4,v5,v6,NUM) 
The result of num is 340


Discussion

No Comment Found

Related InterviewSolutions