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

In pl/sql, what is bulk binding, and when/how would it help performance?

954

Why do we create views in sql?

1072

Is sql microsoft?

990

Sql technical questions

1221

How do you sort in sql?

965

Define tables and fields in a database

1089

What is use of term?

1014

Is sql sequential or random?

993

How do I write a sql query in pgadmin 4?

938

How do you optimize a stored procedure query?

951

What is flag in sql?

994

What operators deal with null?

1041

how are mysql timestamps seen to a user? : Sql dba

1070

What is the difference between left outer join and left join?

958

What is meant by truncate in sql?

1018