What is nvl function?

Question Posted / guest

4 Answers
12064 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is nvl function?..

Answer / raveendran

In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.

The syntax for the NVL function is:

NVL( string1, replace_with )

string1 is the string to test for a null value.

replace_with is the value returned if string1 is null.

Is This Answer Correct ?

20 Yes

2 No

What is nvl function?..

Answer / the superstar rajnikanth

NVL(F,E)
if F is null,it returns expression E.F can be of any type.
the type of E should be the same as that on the left-hand side.

Is This Answer Correct ?

4 Yes

0 No

What is nvl function?..

Answer / shivaindu

In Oracle/PLSQL, the NVL function lets you substitute a
value when a null value is encountered.

The syntax for the NVL function
-------------------------------

NVL( string1, replace_with )

Example #1:
----------

select NVL(supplier_city, 'n/a' or ‘0’)
from suppliers;

Is This Answer Correct ?

1 Yes

0 No

What is nvl function?..

Answer / dinesh kumar

Converts Null value to Absolute for calculation.

Ex : nvl(commission,0) returns 0 when commission is null.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the different schemas objects that can be created using pl/sql?

0 Answers

can i create trigger on synonym is it possible or not please help me

4 Answers CGI,

what is the different between unique+not null & primary key,

4 Answers

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers Accenture,

What are the default Oracle triggers??

3 Answers CGI, Tech Mahindra,

What are the two parts of design view?

0 Answers

display null value rows with out using null function?

8 Answers Infosys,

Which one is better subquery or joins?

0 Answers

what is difference between delete and truncate commands? : Sql dba

0 Answers

How do I view a view in sql?