Answer / kiran kumar

Triggers:
--------

1)Defined with create trigger
2)The data dictionary contains source code in the user_triggers.
3)Implicitly invoked
4)Commit, save point and rollback are not allowed(TCL)

Procedures:
-----------

1)Defined with create procedure
2)Data dictionary contains source code in user_source
3)Explicitly invoked
4)Those are allowed

Note: compare both ones with numbers mentioned..

Answer / suresh.somayajula

1. Triggers are implicitly invoked but

procedures are explicitly invoked.

2. in Triggers TCL commands are not allowed.

TCL commands are allowed in Procedures.

what is global tempory table?

1 Answers   BirlaSoft,

---

What do you understand by a set of books?

0 Answers  

---

How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers  

---

what is fiscalcalendar?

3 Answers   CTS,

---

what is Flex mode and Confine mode?

2 Answers   Rapidigm,

---

---

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

---

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

---

what is the data type of lexical parameter?

5 Answers   Wipro,

---

what are the receipt types in Po?

2 Answers   Evosys, UST,

---

Tell me where we find the status of order information?

0 Answers  

---

How is choreography different from orchestration?

0 Answers  

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---