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 to write html code in pl sql?

1059

What is trigger in sql?

1029

Which join is default?

898

What is the reports view in oracle sql developer?

928

How would you convert date into julian date format?

949

What is posting?

990

What is sql query optimization?

1023

Does sql*plus also have a pl/sql engine?

1039

How do you rank data in sql?

938

Does a join table need a primary key?

904

What do you think about pl/sql?

950

How does sql store data?

867

What is full form of rtm?

953

Is there a 64 bit version of ssms?

896

Can we use distinct and group by together?

994