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 the use of set statement in tsql? : Transact sql

1002

what is timestamp in mysql? : Sql dba

1068

what is row? : Sql dba

1222

What is error ora-01000: maximum open cursors exceeded

1135

What is sql basics?

1037

What is execute immediate?

1078

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

1080

What is a recursive stored procedure?

1167

how tsql statements can be written and submitted to the database engine? : Transact sql

978

How do we use distinct statement? What is its use?

1025

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1134

What are the various levels of constraints?

1121

What is pl/sql table? Why it is used?

1030

How to change sql*plus system settings?

1048

What does rownum mean in sql?

1017