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
Give the different types of rollback segments.
What is open database communication (odbc) in oracle?
List out the components of logical database structure of oracle database.
What privilege is needed for a user to delete rows from tables in another schema?
How do I spool to a csv formatted file using sqlplus?
What is SQL access advisor in Oracle?
6. Display the client name and order date for all orders using the traditional method.
What is the use of file param in imp command?
When system tablespace is created?
What is a proxy object?
How to delete a column in an existing table?
How to import one table back from a dump file?
how can we store any pdf file in oracle
What is a cursor in oracle?
How to use group functions in the select clause using oracle?
