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
- 7660 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / babuli
select ename from emp where (address1 is not null or address2
is not null or address3 is not null) and
((address1 is null and address2 is null ) or (address1 is
null and address3 is null ) or (address2 is null and address3
is null ))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to assign query results to variables?
What is a view and how is it different from a table?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What is meant by raw datatype?
What are the various oracle database objects?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to assign a table row to a record variable?
How to loop through a cursor variable?
Explain constraining triggers.
What is an external table?
What is user managed backup in Oracle?
What are the differences between blob and clob in oracle?
What do you know about normalization? Explain in detail?
How to count groups returned with the group by clause in oracle?
What are the database administrators utilities available?
