difference between procedures and function?

Answers were Sorted based on User's Feedback



difference between procedures and function?..

Answer / nageswararao.k

procedures and functions are subprograms but triggre is not
a subprogram.
procedure:--once we create a procedure we can use that
procedure from any pl/sql block and any front end
application like java,.net applications.no need to execute
every time.
function:----using function ,we can reuse the code and
passed values though perameteres from calling function to
declared function.

Is This Answer Correct ?    5 Yes 1 No

difference between procedures and function?..

Answer / 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

difference between procedures and function?..

Answer / brahma412

i think procedure does not return any values.
but fuction returns value

Is This Answer Correct ?    4 Yes 3 No

difference between procedures and function?..

Answer / harika

we can insert images through procedures

but function may not

Is This Answer Correct ?    2 Yes 2 No

difference between procedures and function?..

Answer / quesanswer

1. Functions must return a value(scalar,inline table or
multi statement table) whereas stored proc may or may not
retun a value.
2.Functions can return a table whereas stored procs can
create a table but can't return table.
3. Stored procs can be called independently using exec
keyword whereas function are called using select statements.
4. Stored procs can be used to change server
configuration(in terms of security-i.e. setting granular
permissions of user rights) whereas function can't be used
for this
5. XML and output parameters can't be passed to functions
whereas it can be with sp's.
6.transaction related statement can be handled in sp whereas
it can't be in function.
7. stored procedures can call a funtion or another sstored
proc similarly a function can call another function and a
stored proc.The catch with function is that no user defined
stored proc can be called.Only extended/system defined procs
can be called.

Is This Answer Correct ?    0 Yes 0 No

difference between procedures and function?..

Answer / s.ramadevi

procedure,function both are subprograms.But procedure dont
return the value,function only return the datatype.

Is This Answer Correct ?    0 Yes 0 No

difference between procedures and function?..

Answer / mk

Function:-
A function is a predefined action which can consumed so that
retrieve the information from table in various scenario .
Procedure :-
procedure are SQl and PL/SQL code compile and stored in the
database.

Difference
Procedure

It may or may Not return a value
It can return multiple value also
It has both Input & output parameter
Doesn’t uses return statement for returning a value
Output Parameter will be specify using Output Clause
This allow select as well as DML operation
It support Transaction mgmt and error-handling using TRY and
Catch Block
They can call another procedure and function for Execution

Function
Function

It Must return a value
It can return only single value
It has both Input parameter
Uses return statement for returning a value
Output Parameter will be specify using Return Clause
This allow select as statement
Doesn’t support Transaction mgmt and error-handling using
TRY and Catch Block
They can call only another function for Execution



When will use :-

We will use procedure to perform complex business Logic as
well as we use function while performing simple
mathematical calculation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

what is the output of select * from emp where null=null & select * from emp where 1=1

8 Answers   IMS Health, NIIT,


Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

0 Answers  


What is a public synonym?

1 Answers  


What is a server parameter file in oracle?

0 Answers  


What are steps required to ENTER DATA INTO DWH?

2 Answers  


What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,


can you write commit in triggers?

4 Answers  


Point out the difference between user tables and data dictionary?

0 Answers  


What is an oracle tablespace?

0 Answers  


How can we find the size of a database?

2 Answers  


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  


How to rename an existing table?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)