Interested to Buy Any Domain ? << Click Here >> for more details...
Diff bet.. Function and Trigger?
- 3 Answers
- 7065 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 is the use of setFetchSize() and setMaxRows() methods in Statement?
What are the methods which can verify the cursor particular position?
What will happen when ResultSet is not closed?
What is jdbc odbc connection?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
how can connection with oracle10g with java
Compare jdbc and odbc and how is jdbc required in this context.
What are types of resultset?
What isolation level is used by the DBMS when inserting, updating and selecting rows from a database?
Can we return resultset in java?
What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?
How to use JDBC to connect Microsoft Access?
Core Java 
