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

Explain what is sql?

1109

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

How to use transactions efficiently : transact sql

1050

Why we use sql profiler?

950

What is the purpose of a secondary key?

958

Can you call pl/sql package functions from within a fast formula?

1033

What is sql partition function?

1196

What does count (*) do in sql?

1003

What does the file extension accdb stand for?

965

Describe types of sql statements?

1052

What are sql functions? Describe the different types of sql functions?

1136

What is a dynamic query?

1016

Can we connect to postgresql using sql developer?

997

Explain the methods used to protect source code of pl/sql.

1012

How to use sql statements in pl/sql?

1112