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 / ajit
select *from addr1 where add1 is not null and add2 is null
and add3 is null or add1 is null and add2 is not null and
add3 is null or add1 is null and add2 is null
and add3 is not null
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to create an oracle testing table?
How to connect to a remote server?
What is hot backup and logical backup?
Is postgres faster than oracle?
How to add another datafile to a tablespace?
What is the difference between "as" and "is" in an oracle stored procedure?
What is a sub query? What are its various types?
What are the different types of synonyms?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to fetch the row which has the max value for a column?
What is meant by an index?
What is oracle database client?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What privilege is needed for a user to create tables in oracle?
Where do you use decode and case statements?