Diff bet.. Function and Trigger?

Question Posted / rdharmendra

3 Answers
5914 Views
Logica CMG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diff bet.. Function and Trigger?..

Answer / srinivas t

Triggers: are special class of stored procedures to execute
automatically when an update,insert or statement is issued
against a table or view.
Function:Function is used to return value after performing
the tasks to the callable fucntion.

Is This Answer Correct ?

14 Yes

0 No

Diff bet.. Function and Trigger?..

Answer / purushotham

PL/SQL has two types of sub programs
Function and Procedures.
A Trigger is a stored procedure which is implictly called
by the oracle engine when an DML action is performed.
Trigger consists of three parts
A trigger statement
A trigger restriction
and the triggering action

Functions are different from procedures as
functions return value whereas procedure doesnt
To carry out set of tasks a certain pl/sql statements are
grouped in a procedure.
After performing some tasks and returns the result(function)
functions are written explicitly by the user.

Is This Answer Correct ?

1 Yes

0 No

Diff bet.. Function and Trigger?..

Answer / dsr

Function returns the value.Trigger is not complusory return
the value.

Is This Answer Correct ?

2 Yes

6 No

Post New Answer