how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

0 Answers  

---

what is trigger?

6 Answers   Oracle,

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth

1 Answers   Wipro,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

---

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 the difference between sharding and replication?

0 Answers  

---

Write a syntax for update query in oracle?

0 Answers  

---

What is Segment Advisor in Oracle?

0 Answers   MCN Solutions,

---

how to create a new database in oracle?

6 Answers   TCS,

---

How to pass a cursor variable to a procedure?

0 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---