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.
Answer Posted / girija.112
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 |
Post New Answer View All Answers
What are temporal data types in oracle?
What privilege is needed for a user to create tables in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Explain the use of rows option in imp command.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Can we use bind variables in oracle stored procedure?
What is oracle open database communication (odbc)?
How to change system global area (sga) in oracle?
What is define in oracle?
Why is oracle database so popular?
How to find the duplicate rows count from employees table in oracle?
what is the dual table in oracle?
What is ordinary table in oracle?
Explain oracle insert into command?
How to invoke the original export import utilities?