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 did my jdbc code throw a rollback sqlexception?
What is jdbc and jdbc drivers?
Where is mysql jdbc driver located?
What is getconnection method in java?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
Is not bound in this context unable to find jdbc spring boot?
Is jdbc a middleware?
Is java a database?
What is difference between statement and preparedstatement in jdbc?
Is jdbc part of j2ee?
Why do we need jdbc driver?
What is createstatement method in java?
How can I determine where a given table is referenced via foreign keys?
What is the use of jdbc?
Explain about DSN?
