Diff bet.. Function and Trigger?
- 3 Answers
- 6379 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 |
How can I connect mysql or oracle with java?
Is possible to open a connection to a database with exclusive mode with JDBC?
How vendor Naming registry supports JNDI?
What is SQL Warning? How to retrieve SQL warnings in the JDBC program?
What is database null and Java null?
How many ways can you update a result set?
What is jdbc architecture?
What are the differences between statement and preparedstatement interface?
RowSetInternal caller and returns void. What can I do in the readData method?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
What is use of connection pooling?
How does a custom RowSetReader get called from a CachedRowSet?
Core Java 
