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
4981 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 is bulk load in oracle?

1051

What are oracle functions?

1010

How many types of tables are there in oracle?

1043

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1030

what is reindexing?

1649

How can I introduce multiple conditions in like operator?

970

How to use group functions in the select clause using oracle?

1053

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1093

List out the types of joins.

1137

How to put more than 1000 values into an oracle in clause?

1013

How can I combine multiple rows into a comma-delimited list in oracle?

1039

How to open and close an explicit cursor in oracle?

1031

What is sequence?

1060

What are the predefined tablespaces in a database?

1056

Give syntax for SQL and ORACLE joins.

1077