Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nageswararao.k
procedures and functions are subprograms but triggre is not
a subprogram.
procedure:--once we create a procedure we can use that
procedure from any pl/sql block and any front end
application like java,.net applications.no need to execute
every time.
function:----using function ,we can reuse the code and
passed values though perameteres from calling function to
declared function.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the Tune Query
How to install oracle database 10g xe?
How to download oracle database 10g xe?
How to assign data of the deleted row to variables?
Can multiple cursors being opened at the same time?
What privilege is needed for a user to create views in oracle?
How to view the data files in the current database?
what is the difference between data migration and production migration.
How to create an oracle database manually?
How to resolve the ORA-39133 error in Oracle?
What are the general rules on data consistency?
How to pass a parameter to a cursor in oracle?
Explain an exception?
What are the various types of snapshots ?
What is an oracle database table?
