What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.

Answers were Sorted based on User's Feedback



What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Pac..

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

Is This Answer Correct ?    11 Yes 1 No

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Pac..

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.

Is This Answer Correct ?    6 Yes 0 No

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Pac..

Answer / pratap557

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

Is This Answer Correct ?    4 Yes 0 No

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Pac..

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..

Is This Answer Correct ?    6 Yes 3 No

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Pac..

Answer / pratap557

We cannot write DML in Function whereas in SPs we can

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

What is the definition for sql server 2000?

0 Answers  


WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,


Explain about system database?

0 Answers  


when inserting to a table how many rows will be effected using triggers

2 Answers  


What is difference between delete & truncate commands?

0 Answers  


Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,


What is etl - extraction, transformation, and loading?

0 Answers  


How to Run a Query on a Remote SQL Server?

2 Answers  


How many types of objects are there?

0 Answers  


Differentiate between truncate vs delete in mssql?

0 Answers  


How to use values from other tables in update statements in ms sql server?

0 Answers  


How to use subqueries with the exists operators in ms sql server?

0 Answers  


Categories