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

Explain the commit statement.

1215

How to rename a column in the output of sql query?

1124

what is view? : Sql dba

1029

What is procedure and function in sql?

1045

how to delete an existing column in a table? : Sql dba

1061

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

1494

What is inner join in sql?

1135

How is indexing done in search engines?

1021

Is left join faster than inner join?

1168

Differentiate between syntax and runtime errors.

1239

Explain the savepoint statement.

1135

What is nvl?

1114

What is a pl/sql block?

1326

What is the difference between a database and a relational database?

1155

What if we write return in procedure?

1511