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
- 7470 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
What is a user role in oracle?
State some uses of redo log files?
How many data types are supported?
Who developed oracle & when?
Explain mutating triggers.
How to drop an existing view in oracle?
Difference between hot backup vs. Cold backup?
How different is ms access and oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Can multiple columns be used in group by in oracle?
Can we create trigger on materialized view in oracle?
What happens if variable names collide with table/column names?
How to create a temporary table in oracle?
What is oracle rownum?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
