Interested to Buy Any Domain ? << Click Here >> for more details...
Diff bet.. Function and Trigger?
- 3 Answers
- 7073 Views
- Logica CMG, I also Faced
- E-Mail Answers
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 does adapter class provide?
Are there any ODBC drivers that do not work with the JDBC- ODBC Bridge?
Does jdbc require oracle client?
Briefly tell about the jdbc architecture.
is java pure object oriented or not ?
How to make updates to updatable result sets in jdbc?
what are the drawbacks of JDBC? explain briefly?
What is db client?
How do I insert/update records with some of the columns having NULL value?
What are the main components of JDBC ?
JDBC Drivers properties?
What is the use of getGeneratedKeys() method in Statement?
Core Java 
