What are the difference between Functions/Stored Procs and Triggers and where

What are the difference between Functions/Stored Procs and
Triggers and where are they used.

Question Posted / sql2000

1 Answers
5155 Views
CGI, TCS, I also Faced
E-Mail Answers

What are the difference between Functions/Stored Procs and Triggers and where are they used...

Answer / barun

Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)

Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_

trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)

Is This Answer Correct ?

8 Yes

0 No

Post New Answer