Select * From Emp where NVL(TO_CHAR(COMM),'NULL VALUE ROW')='

display null value rows with out using null function?

Question Posted / debashis mohanty

Answer Posted / debashis mohanty

Select * From Emp where NVL(TO_CHAR(COMM),'NULL VALUE ROW')='NULL VALUE ROW';

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we use joins in sql?

908

Is t sql a programming language?

1005

What is right join sql?

920

How do you write an index?

913

What is a schema? How is it useful in sql servers?

1042

Is sql free?

887

Is it possible to include an insert statement on the same table to which the trigger is assigned?

956

What is raw datatype in sql?

980

Why do we need databases?

985

How do you identify a primary key?

1011

Which are the different types of indexes in sql?

991

What is the difference between join and natural join?

881

What is difference between joins and union?

1043

What is an inconsistent dependency?

979

What is a relationship and what are they?

1049