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

How do you drop a trigger?

0 Answers  

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

what are the 'mysql' command line arguments? : Sql dba

0 Answers  

What is rtm stands for?

0 Answers  

what is data integrity? : Sql dba

0 Answers  

Why are sql stored procedures used?

0 Answers  

how u can find the n row from a table?

19 Answers   Tech Mahindra,

Is mariadb nosql?

0 Answers  

How to run sql*plus commands in sql developer?

0 Answers  

Can a foreign key be a duplicate?

0 Answers  

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

What are the steps for performance tuning.

0 Answers