Answer / scorpio.mishra

1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins

Answer / darshan shah

SP may return value or may not ,function always treturn
value.
SP cannot use in sselect statment or in sql stattment ,We
can use Function in any where in sql statment.
Packeage is set of statment,SP,Function Which run one by
one statment in that.

Answer / pratap557

In general SPs are sequential block of PL/SQL for
Transaction
Func are used for specific calculation / selection

Answer / bunty_18

1>Stored procedure is pre-executed block of code whereas
function is not.
2>Stored procedure may return zero,one or more than one value
whereas function always return one and only one value..
3>We can use try catch block in stored procedure whereas
function doesn't support try catch block...
4>We can't use stored procedure in select statement whereas we
use function in select statement..

Answer / pratap557

We cannot write DML in Function whereas in SPs we can

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

What is the contrast between sql and pl/sql?

0 Answers  

Is port 1433 secure?

0 Answers  

Why we need a group by clause?

4 Answers  

between cast and convert which function would you prefer and why?

0 Answers  

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

What is a trace frag?

0 Answers  

What are the main control-of-flow T-SQL constructs?

1 Answers  

what is the purpose of creating view is sql server 2000

13 Answers   Wipro,

What are partitioned views and distributed partitioned views?

0 Answers  

Explain sql server authentication modes?

0 Answers  

Explain ms sql server reporting services vs crystal reports?

0 Answers