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 can you load microsoft excel data into oracle? : aql loader

615

What is clause in sql?

586

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

620

How to handle bulk data?

892

What is a common use of group by in sql?

592

what are the type of locks ? : Sql dba

529

What does the acronym acid stand for in database management?

546

How do I filter in sql profiler?

538

Is a view faster than a stored procedure?

549

Why stored procedures are faster than query?

570

What is a sql schema used for?

546

What is trigger in sql? Explain

538

What is pl sql code?

593

What is index example?

560

What is a join query?

553