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
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Explain about the Try Block?
What is jdbc and explain jdbc architecture?
How many categories of jdbc drivers are there?
What are the conditions applies to varchar variable, when using in procedures?
What are the different types of JDBC drivers?
What is com mysql jdbc driver?
What is serialization and deserialization in java programming?
Explain about DSN?
What is the use of dialect?
How can you know about drivers and database information ?
How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
What are the different types of statements? How we can you use preparedstatement.
What is jdbc servlet?
Explain different types of locks in jdbc?
