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
5029 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

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1935

what is the dual table in oracle?

996

What is a initialization parameter file in oracle?

1040

Is there a function to split a string in plsql?

1068

What is the difference between translate and replace in oracle?

1170

How to build data dictionary view an new database?

1015

How to change user password in oracle?

1033

What are the oracle differences between nvl and coalesce

1150

What is the exact use of Collections?

2144

What is the difference between view and materialized view in Oracle?

1159

What are the most common interview questions on ETL Testing for experience?

1145

What is max rowid in oracle?

1026

How to connect to a remote server?

1130

What is recycle bin in Oracle?

1153

Why packages are used in oracle?

1072