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

Can I call a procedure inside a function?

0 Answers  

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

Mention what are different methods to trace the pl/sql code?

0 Answers  

What is the difference between jpql and sql?

0 Answers  

please explain database architecture..

1 Answers   Infosys,

What is the usage of nvl function?

0 Answers  

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

Is keyword pl sql?

0 Answers  

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

how to sort records in sql?

3 Answers  

What is union and union all keyword in sql?

0 Answers