Interested to Buy Any Domain ? << Click Here >> for more details...
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 the use of setFetchSize() and setMaxRows() methods in Statement?
What are JDBC Best Practices?
What is a merge field?
How the JDBC application works?
How to check jdbc driver version in sql server?
When do we get java.sql.SQLException: No suitable driver found?
What is an odbc driver?
Give steps to connect to the db using jdbc?
java based application for hospital management
What is a statement?
What are the ddl statements?
What causes the "No suitable driver" error?
Name the method, which is used to prepare a callablestatement.
What is jdbc template?
What are the different types of JDBC drivers?
