Diff bet.. Function and Trigger?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is isolation level? How to set it?

1879


How can I manage special characters when I execute an insert query?

718


How can I retrieve a String or other object type without creating a new object each time?

870


What is jdbc in java?

669


What does jdbc stand for?

671


What is the major difference between java.util.date and java.sql.date data type?

665


What is difference between jdbc and odbc?

692


Compare jdbc and odbc and how is jdbc required in this context.

699


Which database is used for java?

720


How do I load a database driver with JDBC 4.0 / Java 6?

753


What is jdbc stand for?

694


What is JDBC Savepoint? How to use it?

857


What are the steps to connect to the database in java?

709


What is resultsetmetadata?

670


How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?

803