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.

In a table their 20 records.I had update 6 records???How can see and retrieve particular 6 records.i.e.,Latest updated.

10 Answers   HCL, TCS,

---

While importing data into interface tables,if u got number of records are error(like more than 1000 records are error),how to imform user?

2 Answers  

---

Is SOB is attached with Business grp ?

2 Answers   Convergys,

---

for report i have to parameters those are from_date and to_date ,so to_date should be greater when compare to from_date ,if we are giving to_date is less then it must shows some error how we willmake

3 Answers  

---

explain p2p cycle? what are the tables used for this?

3 Answers   Accenture,

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

0 Answers   IBM,

---

why r u transer the data base tables to flat file and what is use

2 Answers  

---

testing tools?

0 Answers   BirlaSoft, Convergys,

---

PL/SQL stored procedure parameters?

7 Answers  

---

How you will Diaplay the Company LOGO In report.Can anyone knows please give solution

8 Answers   TCS,

---

Form development process?

1 Answers  

---

which parameters passed in report in oracle developer how to pass

1 Answers   Wipro,

---