In Case of NUMBER Data Type Column select comm from emp where nvl(to

display null value rows with out using null function?

Question Posted / ajit

Answer Posted / ajit

In Case of NUMBER Data Type Column

select comm
from emp
where nvl(to_char(comm),'#') = '#'

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

546

Is join same as left join?

521

What does sql stand for?

537

What is int identity in sql?

568

What is error ora-01000: maximum open cursors exceeded

598

explain primary keys and auto increment fields in mysql : sql dba

514

What are different types of sql commands?

500

Explain the the delete statements in sql?

571

what is commit? : Sql dba

608

what is a stored procedure? : Sql dba

543

Can we create foreign key without primary key?

525

What is a call statement? Explain with an example.

539

What is count * in sql?

543

How do I partition in sql?

531

Are left and right joins the same?

525