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 move files from one directory to another in pl sql?

642

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

530

How do I create an index in word?

542

Is primary key always clustered index?

540

What plvcmt and plvrb does in pl/sql?

881

Can we use join in subquery?

567

What is procedure explain with example?

542

What are the types of keys?

514

Explain what is a column in a table?

573

Can we create a trigger on view?

491

What are local and global Indexes and where they are useful.

930

How does a trigger work?

538

What is type and rowtype in pl sql?

538

How we can update the view?

603

how to convert character strings to numeric values? : Sql dba

578