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
- 7804 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 truncate oracle?
How to delete a column in an existing table in oracle?
How to apply filtering criteria at group level in oracle?
defination of bitmap index
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
Why is oracle used?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is a data lock in oracle?
What is the usage of merge statement?
What are the different types of failures that occur in Oracle database?
What is oracle database client?
what is the use of system.effective.date variable in oracle?
What are the set operators union, union all, minus & intersect meant to do?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is an external table?
