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 are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1090

Is sqlexception checked or unchecked?

1008

What is native sql query?

1074

define join and explain different type of joins? : Sql dba

997

Is sql scripting language?

1110

what are the types of subquery? : Sql dba

1155

What are sql functions? Describe in brief different types of sql functions?

1177

Which sql most popular?

1027

how to include numeric values in sql statements? : Sql dba

1145

What is trigger in sql? Explain

1039

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1014

What are operators available in sql?

1095

Can instead of triggers be used to fire once for each statement on a view?

1006

Does sql full backup truncate logs?

1076

What is a primary key sql?

1093