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 to define a variable to match a table column data type?
What are set operators?
What are internal user account in oracle?
What is tns service name?
What is the recommended interval at which to run statspack snapshots, and why?
Is oracle an operator?
How to download oracle database 10g xe?
What happens to the current transaction if the session is killed?
How do I connect to oracle?
what are bitmap indexes? How does they work?
How to insert a record into a table?
How to speed up webrick?
How to Truncate Table in Oracle
What are the tools for Oracle ?
how to handle exceptions in post production
