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
- 7802 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 are the differences between lov and list item?
How to create a new oracle data file?
How many file formats are supported to export data?
Can you create a synonym without having a table?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Difference between inner join vs where ?
How do I limit the number of rows returned by an oracle query after ordering?
How to display row numbers with the records?
What is index-organized table in Oracle?
What are privileges and grants?
What do you understand by a database object? Can you list a few of them?
Explain the use of record option in exp command.
What privilege is needed for a user to create views in oracle?
What are the various constraints used in oracle?
What is save point in oracle database?
