Select Empno, Decode (Comm,Null,0,Comm) Comm From Emp; Select Empno, Cas

display null value rows with out using null function?

Question Posted / noor

Answer Posted / noor

Select Empno, Decode (Comm,Null,0,Comm) Comm From Emp;

Select Empno, Case When Comm Is Null Then 0 Else Comm End Comm From Emp

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How much does sql cost?

735

How to download oracle sql developer?

849

What is AUTH_ID and AUTH_USER in pl/sql ?

1940

How many types of tables are there?

694

What are the operators used in select statements?

773

What is schema in sql?

683

What is database sql?

709

What are procedures used for?

703

What is the starting oracle error number? What is meant by forward declaration in functions?

738

What are the various restrictions imposed on view in terms of dml?

692

Explain what is a column in a table?

764

What is application trigger?

733

What is a sql schema used for?

729

What is the execution plan in sql?

758

how do you control the max size of a heap table? : Sql dba

702