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

1 Answers   Exilant,

---

How to assign query results to variables?

0 Answers  

---

Explain compound trigger in oracle?

0 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

How do I limit the number of oracle database connections generated by weblogic server?

0 Answers  

---

How to call a stored function in oracle?

0 Answers  

---

If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

Can we create trigger on view in oracle?

1 Answers  

---

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

---

How to invoke the original export import utilities?

0 Answers  

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

2 Answers   Wipro,

---