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
- 5116 Views
- Wipro, I also Faced
- E-Mail Answers
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 is the database name in oracle?
What is the exact use of Collections?
How to retrieve values from data fields in record variables?
How to work with data objects interactively?
What is Java Pool in Oracle?
How to compare dates in oracle sql?
What are the differences between interval year to month and interval day to second?
what happened to the global index when I truncate the data in one of the partition?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What happens if you set the sga too low in oracle?
Is postgres faster than oracle?
How to use regular expression in pattern match conditions in oracle?
How to define a data source name (dsn) in odbc manager?
material view and view disadvantages?
What is a snapshot in oracle database?
