select *from addr1 where add1 is not null and add2 is null and add3 is nul

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 / ajit

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

Answer Posted / ajit

select *from addr1 where add1 is not null and add2 is null
and add3 is null or add1 is null and add2 is not null and
add3 is null or add1 is null and add2 is null
and add3 is not null

Is This Answer Correct ?

0 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the various oracle database objects?

996

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4115

please explain.. DB architecture ...

1968

What is index in Oracle?

1014

Explain an index segment?

1043

WHAT IS ecc 6.0

2103

List the parts of a database trigger.

990

What is connection pool in oracle?

930

Can a formula column be obtained through a select statement ?

2267

Â What are the oracle DML commands possible through an update strategy?

1006

How to use subqueries with the in operator using oracle?

1033

How to call a stored function in oracle?

953

Explain how are indexes update?

1016

Why does for update in oracle 8 cause an ora-01002 error?

935

How data locks are respected in oracle?

1013