How can I execute Procedure, function and Trigger in 10g oracle data base.?

Answer 1

a trigger will be called when you do an insert, update or delete on the table on which the trigger is defined

a function will be called when the procedure, definition or query that uses it needs the result

a procedure is called by executing it from some application or schedule