select * from emp where nvl(to_char(comm),'null')='null'

display null value rows with out using null function?

Question Posted / ansupriya

Answer Posted / ansupriya

select * from emp where nvl(to_char(comm),'null')='null';

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is sql in java?

539

What are the different types of functions in sql?

509

What is a recursive join sql?

588

What is t sql used for?

544

What are the types of join in sql?

512

Does varchar need length?

514

What is rowid in sql?

498

Can we join same table in sql?

517

Write an sql query to select all records from the table?

551

When is a declare statement required?

666

How do I find duplicates in sql?

497

What is the difference between stored procedure and view?

524

Explain select statements in sql?

577

Can you call pl/sql package functions from within a fast formula?

558

What is meant by temporal data?

532