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
What is odbc jdbc?
Explain Basic Steps in Writing a Java Program Using Jdbc?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
Which jdbc driver type s is are the jdbc odbc bridge?
What is ojdbc14 jar?
What should be done for auto generating primary key id in a table ?
What is executeupdate in java?
What is the role of class.forname while loading drivers?
Is it possible to connect to multiple databases simultaneously?
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
What is the return type of class.forname() method?
Can I get a null resultset?
Explain the two tier and three tier architecture of jdbc.
Explain the main method?
What are the packages are used in jdbc?