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 meaning of <> in sql?

1123

What are the two characteristics of a primary key?

1029

what is the difference between cluster and non cluster index? : Sql dba

1070

Is primary key clustered or nonclustered?

1056

What are all different types of collation sensitivity?

1075

How many types of keys are there in sql?

1080

What are the disadvantages of not performing database normalization?

1210

what is the use of double ampersand (&&) in sql queries?

1216

How does cross join work?

1000

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1145

Is left join inner or outer by default?

1067

Can I call a procedure inside a function?

1071

What is the difference between inner join and left join?

1034

how can we submit a form without a submit button? : Sql dba

1031

What is a full join sql?

1099