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

What are pl/sql packages?

1102

what is innodb? : Sql dba

1099

What is synonyms?

1057

Where is pl sql used?

951

Can cursors be part of a trigger body?

1639

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1065

Which constraints we can use while creating database in sql?

1079

tell me about various levels of constraint. : Sql dba

1035

Why do we go for stored procedures?

1057

What are character functions?

1085

Name three sql operations that perform a sort.

1007

How is sql used in oracle?

1005

How do you truncate?

906

How to display the current date in sql?

1075

What is oracle and pl sql?

1118