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
- 7595 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
Why do we need integrity constraints in a database?
State any two functions of oracle?
How to drop a tablespace?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the differences between interval year to month and interval day to second?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is varray?
State all possible different index configurations a table can possibly have?
How do I find the database name in oracle?
Can we insert data in view oracle?
Differentiate between function and procedure in oracle.
How to execute a stored procedure in oracle?
What is the usage of save points in oracle database?
How to retrieve the count of updated rows?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
