select * from order_line where ( (itemnum between 1 and 200) or itemnum &

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 / suman rana

3 Answers
4982 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / suman rana

select * from order_line
where ( (itemnum between 1 and 200) or itemnum >100)
and not (cost in (1000,2000,3000) or ordernum = 1000)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

query optmization techniques and quwry analyser+projects+ppts

2403

What is oracle and what are its different editions?

1054

How can you merge two tables in oracle?

973

What is ADDM Advisor in Oracle?

1158

what are the default admin accounts in Oracle 10g ?

954

Is it possible to split the print reviewer into more than one region ?

2260

What is literal?

987

What would you do with an in-doubt distributed transaction?

1958

What happens if you lost a data file?

1027

What happens if recursive calls get out of control?

1060

What is the parameter mode that can be passed to a procedure?

1021

Please explain oracle data types with examples?

1038

Explain what are clusters?

1087

What is the use of file param in imp command?

1147

How would you go about verifying the network name that the local_listener is currently using?

2027