Select ename from employee where to_char(nvl2(address1,'1',

Hi all,
Can any one give answer for this question.
Suppose im having employee table with fields, eno, ename,
dept, address1, address2, address3.
In address field employee can fill only address1 or address2
or address3... at a time he can fill three address fields.
now i want all employee names who filled only one address
field.. Plz its urjent can any one give querry.. Thanks in
advance.

Question Posted / jigar

4 Answers
7476 Views
JPMorgan Chase, I also Faced
E-Mail Answers

Answer Posted / jigar

Select ename from employee
where
to_char(nvl2(address1,'1','0')||nvl2(address2,'1','0')||nvl2(address3,'1','0'))
in ('100','010','001')

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I uninstall oracle client from windows?

962

How to start a specific oracle instance?

992

Explain the characteristics of oracle dba?

1069

How do I start tns listener?

990

How do you find current date and time in oracle?

991

What happens if the imported table already exists?

974

What is a lookup table in oracle?

934

What are privileges and grants?

1005

what is IDE,DMV in sql server?

2754

Explain enable novalidate constraint.

1037

How to set a transaction to be read only in oracle?

1033

How to select some columns from a table in oracle?

1007

How many categories of data types in oracle?

963

How to download oracle database 10g xe?

962

How to create lov dynamically at runtime & attach to text field?

1100