select * from table_name where nvl(column

display null value rows with out using null function?

Question Posted / nilesh patil

Answer Posted / nilesh patil

select * from table_name where nvl(column_name,'#')='#';

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how to load data files into tables with 'mysqlimport'? : Sql dba

510

Difference between table function and pipelined function?

574

Name the different types of indexes in sql and define them.

560

What are aggregate functions in sql?

619

What is self-join and what is the requirement of self-join?

624

What is sql scripting?

549

Is null operator in sql?

596

what are null values? : Sql dba

536

how to convert dates to character strings? : Sql dba

531

What is pl sql variable?

500

What is output spooling in sql*plus?

541

What are the benefits of pl sql?

518

What is date functions?

564

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

533

What is sql performance tuning?

486