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
- 7806 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 execute the package in oracle?
How can we find out the current date and time in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the data type of dual table?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain what are the uses of rollback segment?
How to insert multiple rows with one insert statement in oracle?
What are the logical operations?
Can we protect our pl/sql source code?
How to experiment a data lock in oracle?
Explain the use of rows option in imp command.
Explain the use of consistent option in exp command.
What is a system tablespace and when it is created?
What are ddl statements in oracle?
Explain index?
