Answer / guest

You can find here in the following link :
http://oraclebabu.blogspot.com/2008/04/oracle-certification-
to-z_29.html

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,

---

How to define Data Block size ?

2 Answers  

---

What is clustered table in Oracle?

0 Answers   MCN Solutions,

---

Write query to fetch second maximum salary from employee table.

4 Answers   Bravura Solutions, HCL,

---

can you write commit in triggers?

4 Answers  

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---

What are a cluster and non-cluster index?

0 Answers  

---

What is a private synonym?

0 Answers  

---

How to select some columns from a table in oracle?

0 Answers  

---

How to use values from other tables in update statements using oracle?

0 Answers  

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,

---