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
Why hibernate is better than jdbc?
Which is better odbc or jdbc?
What is the feature of jdbc v4?
Describe how the jdbc application works.
Write an sql to find all records having all upper case alphanumeric characters in a field ?
Describe odbc?
What is getconnection method in java?
What are the different types of interfaces in the api component?
Explain the steps in writing a java program using jdbc?
Explain how to make updates to the updatable resultsets.
What are the differences between statement and preparedstatement interface?
Why do we use jdbc?
What is metadata in programming?
What are common JDBC Exceptions?
What types of DataSource objects are specified in the Optional Package?
