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 varchar used for?

750

What are the types of queries in sql?

744

Is full outer join same as cross join?

695

How do I view a view in sql?

697

What is a stored procedure in sql with example?

786

What is an ndf file?

690

How do you rename a table in sql?

737

what are the different functions in sorting an array? : Sql dba

766

What is the difference between truncate and drop statements?

763

What is the advantage of nosql?

735

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

703

How many primary keys can a table have?

722

When you have to use a default "rollback to" savepoint of plvlog?

912

What are the different type of joins in sql?

722

What is a pdo connection?

685