Answer / anil kumar jampana

sorry, we can use in,inout,out parameters in functions also.
one more diff. we can use functions in normal sql queries
but we cann't use procedures in sql queries....

Answer / ace

A function is a special kind of procedure. A function
returns a value in its name. A function can return more
than one value if it returns a ref cursor.

Answer / naresh bs

The main difference is that, a procedure may return and
value but a function has to return a value.

Answer / pankaj mehra

Well the main difference between procedures and function is
that the procedure may/may not return any value.it can
return more than one value also.
but functions can return only one value at a time and it
must have return keyword inside the function

Answer / surajit pathak

We can use in,inout,out parameters in functions also.
The most important difference is we can use functions in
normal sql queries if it is not containing any out
parameters.
but we cann't use procedures in sql queries....

Answer / chandrasekar.ramasamy

Function accepts only in parameter but procedure accepts
in,out and inout
Function mostly used for mathamatical calculations
But procedure used to execute business logics

What is a stored procedure in sql with example?

0 Answers  

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

What is a primary key example?

0 Answers  

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

When is a declare statement required?

0 Answers  

How do I run a sql script?

0 Answers  

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

what is the forward decleration in packages?

1 Answers  

Is sql the best database?

0 Answers  

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

What is the current version of sql?

0 Answers  

What is sqlerrd?

0 Answers