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 bulk collect in pl sql?

0 Answers  

What are operators available in sql?

0 Answers  

How is Oracle 10g helpful when compared to oracle 9i and what is grid computing

1 Answers   Flextronics,

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

What is form and report?

0 Answers  

Which normal form is best?

0 Answers  

What is rename command in sql?

0 Answers  

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

What is the difference between mdf and ndf files?

0 Answers  

What is the difference between inner join and natural join?

0 Answers  

how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers