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 many postgresql users are there, worldwide?

1065

Can a primary key be a foreign key?

1023

What are the three pl sql block types?

1010

How to run sql statements with oracle sql developer?

1074

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1193

What are different types of keys?

1106

What is prepared statement in sql?

1056

Can we debug stored procedure?

1031

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1142

What is pl sql script?

1036

What are dml commands?

1023

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

1008

What is auto increment?

1007

What is the use of triggers?

1039

what is row? : Sql dba

1230