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

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

What is an inner join sql?

0 Answers  

What is ttitle and btitle?

0 Answers  

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

What is flag in sql?

0 Answers  

what is data integrity

3 Answers   Fidelity, TCS,

Is pl sql and postgresql same?

0 Answers  

How do I remove duplicates in two columns?

0 Answers  

Explain ttitle and btitle.

0 Answers  

what is explain plan?, given an example...

3 Answers   Polaris,

How do I run sql?

0 Answers