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
- 4887 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 fastest query method to fetch data from the table?
How to define a data field as not null?
How to delete a user account in oracle?
What are the differences between char and nchar in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is raw datatype?
Difference between cartesian join and cross join?
How to specify default values in insert statement using oracle?
Explain database link?
What is the simplest tool to run commands on oracle servers?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Does oracle charge for java?
Can I create users through internet explorer in oracle 10g?
Point the difference between translate and replace?
Explain constraining triggers.
