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 inner outer left and right joins in sql?

505

what is user defined functions? : Sql dba

541

Explain how to use transactions efficiently : transact sql

523

What does := mean in pl sql?

548

Can we use ddl statements in stored procedure?

691

Does sql between include endpoints?

548

Explain the insert into statements in sql?

556

Why do we use partitions in sql?

537

How do you determine the current isolation level? : Transact sql

570

Is grant a ddl statement?

447

What are sql functions? Describe the different types of sql functions?

548

Is join an inner join?

528

What is sql profiling in oracle?

536

what is the difference between join and union? : Sql dba

541

what are the t string functions available in tsql? : Transact sql

533