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.

What is a constraint? Tell me about its various levels.

0 Answers  

---

Why do we use sqlite?

0 Answers  

---

What is a database? Explain

0 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

How do I use google cloud in sql?

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

How many types of cursors are available in pl/sql?

0 Answers  

---

Is sql free?

0 Answers  

---

Explain what is a database?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

Is json a nosql?

0 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---