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 is mutating error in pl sql?

1020

How can you view the errors encountered in a trigger?

962

How do you get column names only for a table (sql server)?

1166

What is the importance of sqlcode and sqlerrm?

1356

how many sql ddl commands are supported by 'mysql'? : Sql dba

1023

How can I speed up sql query?

963

Are sql connections encrypted?

1029

What is consistency?

1126

How do I delete a trigger?

967

how to create a new table by selecting rows from another table in mysql? : Sql dba

1107

What is difference between pl and sql?

1063

What is left join in postgresql?

1047

What is the difference between nvl function, ifnull function, and isnull function?

1113

How does one use sql*loader to load images, sound clips and documents? : aql loader

1187

What is the use of <> sql?

980