Answer Posted / mohit74

acc. to me only 12 trigger combination is there but we can
have more then 12 triggers on table

and the ppl talking abt instead of trigger----guys instead
of trigger is for view not for table so dont get confused.

What are a cluster and non-cluster index?

1001

---

What is the difference between truncate & delete command?

1166

---

How to upsert (update or insert into a table)?

989

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2170

---

What are the uses of synonyms?

1131

---

What is oracle data type?

944

---

What is the meaning of recursive hints in oracle?

1040

---

What is a static data dictionary in oracle?

1087

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2152

---

What is a subquery?

1105

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4335

---

How to get execution path reports on query statements?

967

---

How do I start tns listener?

1030

---

How to call a sub procedure?

1077

---

What privilege is needed for a user to delete rows from tables in another schema?

1049

---