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 does oracle handle read consistency?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the difference between pre-select and pre-query?
How will you identify oracle database software release?
What is an oracle cursor variable?
How to add a new column to an existing table with a default value?
When do you get a .pll extension in oracle? Explain its importance
What are group functions in oracle?
How to create a new table by selecting rows from another table?
What is the meaning of recursive hints in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain about the analyze command in oracle?
How to check database size in Oracle?
How to drop a stored procedure in oracle?
What happens to indexes if you drop a table?
