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.
Answers were Sorted based on User's Feedback
select *
from order_line
where item_number between 1 and 200
or item_number > 1000
intersect
select *
from order_line
where order_number not in (1000,2000,3000)
or order_number <> 1000
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Where are the settings stored for each instance in oracle?
How to download oracle database 10g xe?
In what script is snap$ created? In what script is the scott/tiger schema created?
Explain an integrity constrains?
What is recovery manager 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.
Can Multiple instances be run on Single Machine???
how to see the data (in unix) using dataset in datastage?
How oracle handles dead locks?
Is it possible to split the print reviewer into more than one region ?
What is procedure overloading in oracle?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??