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
How vendor Naming registry supports JNDI?
How to make updates to updatable result sets in jdbc?
What are the different types of resultset?
How data can be inserted into long row column of database?
Why do you use a data source object for a connection?
What is use of connection pooling?
What is setautocommit in jdbc?
Does sql allow null values ? Can we use it within where clause ?
What is jdbc and odbc in java?
How to test jdbc connection to sql server?
What is jdbc stand for?
How do I check in my code whether a maximum limit of database connections have been reached?
How to connect multiple database in jdbc?
Is it possible to connect to multiple databases simultaneously?
Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.
