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 JDBC PreparedStatement?
What do you understand by jdbc driver and explain its types?
What does the jdbc databasemetadata interface?
What is the latest version of JDBC? What are the new features added in that?
What are the differences between setmaxrows(int) and setfetchsize(int)?
What do you mean by batch processing in jdbc?
Explain the importance of drivermanager.
What is a statement?
Can resultset be null in java?
Why we use jdbc instead of odbc?
What is the use of jdbc?
Prepared statements are faster. Why?
List some new features available in jdbc 4.0?
What is jdbc connection class?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
