display null value rows with out using null function?
Answer Posted / debashis mohanty
Select * From Emp where NVL(TO_CHAR(COMM),'NULL VALUE ROW')='NULL VALUE ROW';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Is sqlexception checked or unchecked?
What is native sql query?
define join and explain different type of joins? : Sql dba
Is sql scripting language?
what are the types of subquery? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
Which sql most popular?
how to include numeric values in sql statements? : Sql dba
What is trigger in sql? Explain
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What are operators available in sql?
Can instead of triggers be used to fire once for each statement on a view?
Does sql full backup truncate logs?
What is a primary key sql?