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 get maxsal , minsal, ename department wise in single query
How to shutdown your 10g xe server from command line?
How many file formats are supported to export data?
What are the differences between number and binary_float in oracle?
What is the data pump export utility?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How can we delete duplicate rows in a table?
What is oracle open database communication (odbc)?
Explain what are the uses of rollback segment?
Explain a segment?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain overloading. Can functions be overloaded?
How index is implemented in oracle database?
Explain implicit cursor.
What are the differences between char and nchar in oracle?