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 odbc jdbc?

769


Explain Basic Steps in Writing a Java Program Using Jdbc?

822


How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

794


Which jdbc driver type s is are the jdbc odbc bridge?

662


What is ojdbc14 jar?

680


What should be done for auto generating primary key id in a table ?

740


What is executeupdate in java?

682


What is the role of class.forname while loading drivers?

796


Is it possible to connect to multiple databases simultaneously?

788


Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?

755


What is the return type of class.forname() method?

736


Can I get a null resultset?

743


Explain the two tier and three tier architecture of jdbc.

707


Explain the main method?

790


What are the packages are used in jdbc?

799