Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nageswararao.k
procedure and functions both are subprogrames.but trigger
is not a subprogram
procedure:--a procedure is created to perform one or more
DML operations.if we create procedure,then we can call the
procedure from any frontend application and any pl/sql
block.
procedures may or may not return a value .
we can not call procedure from select statement.
in procedure the out perameter return a value.
function:-the functions are created to do calculatiions and
computations.
function access some input and perform a task and must
return a value.the value return by return statement.
we can call the function from select statement.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How many types of table in Oracle?
What is a sub query and what are the different types of subqueries?
How to create an oracle database manually?
What is blob data type in oracle?
How to add a new column to an existing table in oracle?
How to call a sub procedure?
What is a user role in oracle?
What is the data type of dual table?
Explain database link?
How to estimate disk space needed for an export job?
What is data block in Oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to use "in" parameter properly?
How do I limit the number of oracle database connections generated by weblogic server?
