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

How to look at the current sql*plus system settings?

1140

What is a unique key?

1045

Can we use loop in sql?

964

Can we use insert statement in function?

992

Can a foreign key have a different name?

938

How is data stored in sql?

1048

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

994

what is a composite primary key ? : Sql dba

1039

Does truncate table reset auto increment?

984

how to drop an existing view in mysql? : Sql dba

1050

Is sql open source?

966

What is error ora-01000: maximum open cursors exceeded

1134

What is the usage of sql functions?

1141

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1043

What are secondary keys?

965