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.

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.

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;

Answer / dinesh kumar

Converts Null value to Absolute for calculation.

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

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

How does an execution block start and end in pl sql?

0 Answers  

---

I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT

1 Answers   AOL,

---

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

what is global variable in pl/sql

1 Answers  

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

how to create object in plsql

3 Answers   Microsoft,

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What is the requirement of self-join?

0 Answers  

---

How do I run a program in pl sql?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---