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

What is a sql schema used for?

1044

What is serial sql?

930

how to get a list of all tables in a database? : Sql dba

931

What are the types of subqueries?

1026

Can we use commit inside a trigger?

1036

Why use subqueries instead of joins?

1037

what is the difference between cluster and non cluster index? : Sql dba

968

what is a constraint? Tell me about its various levels. : Sql dba

945

How are sql commands classified?

1043

What is the difference among union, minus and intersect?

957

Is it possible to link two groups inside a cross products after the cross products group has been created?

961

What does the acronym acid stand for in database management?

992

what are the advantages of using stored procedures? : Sql dba

1068

When can we use the where clause and the having clause?

978

How do I create a memory optimized filegroup?

911