Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5118 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How to list all indexes in your schema?
How to use like conditions in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
List out the components of logical database structure of oracle database.
How to display the hierarchy of employee and managers without using connect by prior.
Difference between inner join vs where ?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
List the various oracle database objects?
How to rename an existing table?
How many types of database triggers exist?
What is a OUTER JOIN?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Oracle General 
