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   Wipro,

---

What is program global area (pga) in oracle?

0 Answers  

---

What is the implicit cursor in oracle?

0 Answers  

---

Define the terms primary key foreign key and also the difference between primary and the unique key

2 Answers  

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

Why oracle is used?

0 Answers  

---

What are dml statements in oracle?

0 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

how to we delete a row using varray

3 Answers   CTC,

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

What is flashback Query ? And Use ?

4 Answers   Thermotech,

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---