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

Are null values same as that of zero or a blank space?

967

What are types of indexes in sql?

1006

What makes a good primary key?

980

How do I copy a table in sql?

928

What are primary key and foreign key and how they work?

927

How to create a menu in sqlplus or pl/sql?

1063

What is bind reference and how can it be created?

966

How much ram can sql express use?

930

How do you modify a table in sql?

1062

What is oracle pl sql developer?

934

Write a sql query to convert all character to uppercase after hypen.

1376

Is sql developer case sensitive?

944

How is data stored on a disk?

962

Write the alter statement to enable all the triggers on the t.students table.

1067

How delete all records from table in sql?

928