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 isolation level? How to set it?
How can I manage special characters when I execute an insert query?
How can I retrieve a String or other object type without creating a new object each time?
What is jdbc in java?
What does jdbc stand for?
What is the major difference between java.util.date and java.sql.date data type?
What is difference between jdbc and odbc?
Compare jdbc and odbc and how is jdbc required in this context.
Which database is used for java?
How do I load a database driver with JDBC 4.0 / Java 6?
What is jdbc stand for?
What is JDBC Savepoint? How to use it?
What are the steps to connect to the database in java?
What is resultsetmetadata?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?