Answer / roopesh kumar

(1) Procedure may or may not return value but function
should.

(2) We can't call a procedure inside a sql stmt but
function can.

Answer / guest

Hi,

Basic Difference is Function must return a value and
Procedure can or cannot return a value using out parameter.



Thanks!

Answer / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Answer / shasi

Hi,

The main think is function canbe used in sql select
statement but procedure wer can't use.procedure redurn more
then value(max:1024)funcion must return 1 value

Answer / sandeep sahoo

Prcocedure Will do Action whereas Function Will do Calculation

Answer / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

What is Raise_application_error ?

1 Answers  

How do I run a sql script?

0 Answers  

What is correlated sub-query?

7 Answers   Oracle,

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

Is postgresql a server?

0 Answers  

what are the advantages a stored procedure? : Sql dba

0 Answers  

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

What is the difference between a procedure and a function?

0 Answers