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
- 4928 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
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to use existing values in update statements using oracle?
How to use "in" parameter properly?
Why do we need integrity constraints in a database?
How to rename an existing table?
What is the difference between a hot backup and a cold backup in oracle?
How would you go about verifying the network name that the local_listener is currently using?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How to Truncate Table in Oracle
How do I call oracle stored procedures that take no parameters?
How to check your oracle database 10g xe installation?
Why cursor variables are easier to use than cursors?
How to convert character types to numeric types?
What are the predefined tablespaces in a database?
Can we store images in oracle database?
