select * from order_line where item_number between 1 and 200 or item

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.

Question Posted / girija.112

3 Answers
5129 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

Please Help Members By Posting Answers For Below Questions

What are the predefined tablespaces in a database?

1147

What is difference between sid and service name in oracle?

1019

what are actual and formal parameters?

1165

How to execute a stored program unit?

1128

What do you mean by merge in oracle and how can you merge two tables?

1008

What is different types of joins?

1081

How to test null values?

1156

How to sort the query output in oracle?

1077

What is meant by recursive hints in oracle?

1135

What happens if you lost a data file?

1085

What is a trace file and how is it created in oracle?

1151

How to shutdown your 10g xe server?

1208

How many types of tables are there in oracle?

1118

What is Segment Advisor in Oracle?

1149

What happens in oracle commit?

1082