Answer / venu

total 13 triggers with instead of trigger

how many types of index?

2 Answers   Cap Gemini, TCS,

---

What is a tns service name?

0 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

2 Answers  

---

what is the difference between data migration and production migration.

0 Answers  

---

How do I escape a reserved word in oracle?

0 Answers  

---

What is oracle and what are its different editions?

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

Can a property clause itself be based on a property clause ?

1 Answers   Oracle,

---

Point out the difference between user tables and data dictionary?

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,

---

How to use an explicit cursor without open statements?

0 Answers  

---

What is truncate oracle?

0 Answers  

---