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
- 3862 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / murali
select * from order_line where
itemnum between 1 and 200 or itemnum>100
and
cost not in (1000,2000,3000) or ordernum<>1000
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to install oracle database 10g xe?
What is an external table?
What is the difference between hot backup and cold backup in oracle?
Explain oracle’s system global area (sga).
What is an oracle transaction?
How to add a new column to an existing table with a default value?
What are the ansi data types supported in oracle?
How do I uninstall oracle 11g?
What is an oracle database?
Is insert autocommit in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
candidate key is subset of super key but not vice-verse explain
What is format trigger?
What is program global area (pga) in oracle?
material view and view disadvantages?
