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

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

how to delete an existing column in a table? : Sql dba

0 Answers  

What is nvl?

0 Answers  

What is sqlca in db2?

0 Answers  

What are the different ddl commands in sql?

0 Answers  

What is a schema sql?

0 Answers  

Why do we use sql constraints?

0 Answers  

What is a sql select statement?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers  

What is the difference between the implicit and explicit cursors?

0 Answers  

How many types of keys are there in sql?

0 Answers