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
- 7600 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / nathan
WITH temp AS
(SELECT 1 ID, 'delhi' add1, 'mumbai' add2, 'guj' add3
FROM DUAL
UNION ALL
SELECT 2 ID, NULL add1, 'mumbai' add2, NULL add3
FROM DUAL
UNION ALL
SELECT 3 ID, 'delhi' add1, NULL add2, 'guj' add3
FROM DUAL)
SELECT *
FROM (SELECT ID, NVL (add1, 0) + NVL (add2, 0) + NVL
(add3, 0) address
FROM (SELECT ID, DECODE (add1, NULL, NULL, 1) add1,
DECODE (add2, NULL, NULL, 1) add2,
DECODE (add3, NULL, NULL, 1) add3
FROM temp))
WHERE address = 1;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is an oracle recycle bin?
Is it possible to split the print reviewer into more than one region ?
Point the difference between translate and replace?
What do you mean by cdb and pdb in oracle 12c?
How to lock and unlock a user account in oracle?
What are the numeric comparison operations?
How to use values from other tables in update statements using oracle?
How to check the server version in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to work with data objects interactively?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How do I manually uninstall oracle client?
Explain the difference between a procedure and a function?
Explain oracle left join with an example?
