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 dcl in sql?

694

What are the different sql languages?

740

Why select is used in sql?

694

What are the different types of dbms?

729

Which sql most popular?

728

The select into statement is most often used to create backup copies of tables or for archiving records?

771

what is a trigger in mysql? : Sql dba

786

Can a varchar be a primary key?

699

Are subqueries better than joins?

718

What are all different types of collation sensitivity?

737

What is the command used to fetch first 5 characters of the string?

1096

What is bulk compiling in pl/sql.?

800

What is the use of double ampersand (&&) in sql queries? Give an example

811

What is a sql schema used for?

729

Can we write ddl statements in functions?

798