5. Display full details from the ORDER_LINE table where the
item number is (first condition) between 1 and 200 (no > or
< operators) OR the item number is greater than 1000 AND
(second condition) the item cost is not in the list 1000,
2000, 3000 OR the order number is not equal to 1000.
- 3 Answers
- 3868 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from order_line
where ( (itemnum between 1 and 200) or itemnum >100)
and not (cost in (1000,2000,3000) or ordernum = 1000)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to export your own schema?
Point out the difference between user tables and data dictionary?
What is a dynamic performance view in oracle?
What is the Tune Query
Is it possible to insert comments into sql statements return in the data model editor ?
What is connection pool in oracle?
What are the most common interview questions on ETL Testing for experience?
Explain the use of show option in imp command.
How to delete multiple rows from a table in oracle?
How to drop an existing view in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is a cursor in oracle?
How to use like conditions in oracle?
What is rowid and rownum in oracle?
What are the restrictions on external table columns?
