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 can a pl sql block be executed?

522

Name three sql operations that perform a sort.

578

what is user defined functions? : Sql dba

541

How to pronounce postgresql?

572

what is 'mysqlimport'? : Sql dba

568

Can sql developer connect to db2?

577

which operator is used in query for pattern matching? : Sql dba

539

What is a table?

560

Sql technical questions

767

How do I remove all records from a table?

557

Can we use having without group by in sql?

542

How is indexing done in search engines?

523

How many sql core licenses do I need?

503

What are data types in pl sql?

548

What are the types of records?

522