display null value rows with out using null function?
Answer Posted / nilesh patil
select * from table_name where nvl(column_name,'#')='#';
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are pl/sql packages?
what is innodb? : Sql dba
What is synonyms?
Where is pl sql used?
Can cursors be part of a trigger body?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Which constraints we can use while creating database in sql?
tell me about various levels of constraint. : Sql dba
Why do we go for stored procedures?
What are character functions?
Name three sql operations that perform a sort.
How is sql used in oracle?
How do you truncate?
How to display the current date in sql?
What is oracle and pl sql?