Diff bet.. Function and Trigger?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / dsr
Function returns the value.Trigger is not complusory return
the value.
Is This Answer Correct ? | 2 Yes | 6 No |
What is metadata in jdbc?
How many categories of jdbc drivers are there?
What are the main components of JDBC ?
What protocol does jdbc use?
What are the three parts of a jdbc url?
Why do we need jdbc driver?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What class.forname does, while loading the drivers?
What is executeupdate in java?
What is the difference between Minus, and Intersect?
What is a connection string used for?
How does JDBC differ from ODBC?