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

Does group by remove duplicates?

553

What is varchar data type in sql?

520

Describe sql comments?

564

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

535

How do you optimize a stored procedure in sql?

504

what is not null constraint? : Sql dba

551

What does truncate mean in sql?

536

What is consistency?

715

What is the difference between nvl function, ifnull function, and isnull function?

593

How to raise user-defined exception with custom sqlerrm ?

682

What is null in pl/sql?

626

What is pl/sql table? Why it is used?

565

Can we call procedure in select statement?

520

What is difference between cursor and trigger?

559

What does a pl/sql package consist of?

518