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
- 7678 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
Explain the difference between replace() and translate() functions in oracle?
What language does oracle use?
What is system global area (sga) in oracle?
What happens to indexes if you drop a table?
How to use "out" parameter properly?
What are the tools for Oracle ?
Explain integrity constraints?
Which are the five query types available in oracle?
What is connection pool in oracle?
What is Virtual Private Database in Oracle?
What is the data pump export utility?
What is set verify off in oracle?
Explain the use of full option in exp command.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Can we insert data in view oracle?
