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.
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
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Hi Can any one tell me what are the API's used in requisition import.
What are the oracle differences between nvl and coalesce
Can we protect our pl/sql source code?
What is the order of defining local variables and sub procedures/functions?
What is a cursor variable?
How to see free space of each tablespace?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is backup in Oracle?
What is an oracle function?
List the various oracle database objects?
How to compare dates in oracle sql?
How do I reset a sequence in oracle?
What are the original export and import utilities?
What is oracle database client?