Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 7680 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
What is a oracle database?
How can we find out the duplicate values in an oracle table?
Can you have more than one content canvas view attached with a window ?
What happens if you use a wrong connect identifier?
What happens if the update subquery returns multiple rows?
Difference between inner join vs where ?
What would you do with an in-doubt distributed transaction?
How to write text literals in oracle?
What are the execution control statements?
Difference between hot backup vs. Cold backup?
How data locks are respected in oracle?
defination of bitmap index
Give the various exception types.
Explain a segment?
How to create id with auto_increment on oracle?
