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
Briefly explain what is literal? Give an example where it can be used?
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 to write a query with an inner join in oracle?
What is redo log?
What do you mean by merge in oracle and how can we merge two tables?
Please explain drop constraint oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How do I find my oracle client driver version?
Why should I use oracle database?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What are the limitations oracle database 10g xe?
what is the scenario where you take the database to NoArchivelog mode?
What is ceil and floor in oracle?
Is oracle a language?
