Answer / sushma s

NVL function substitute a value when a null value is
encountered.
NVL2: substitutes a value when a null value is encountered
as well as when a non-null value is encountered.

The syntax for the NVL2 function is:

NVL2( string1, value_if_NOT_null, value_if_null )

string1 is the string to test for a null value.

value_if_NOT_null is the value returned if string1 is not null.

value_if_null is the value returned if string1 is null.

NULLIF: NULLIF function compares expr1 and expr2. If expr1
and expr2 are equal, the NULLIF function returns NULL.
Otherwise, it returns expr1.

Write a query to display the current date in sql?

0 Answers  

---

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Explain lock escalation? : Transact sql

0 Answers  

---

What is the usage of sql functions?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is sqlite used for?

0 Answers  

---

What is constant in pl sql?

0 Answers  

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---