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
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 |
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 |
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 |
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 |
Answer / pratap557
We cannot write DML in Function whereas in SPs we can
Is This Answer Correct ? | 0 Yes | 3 No |
What is the difference between inner join and equi join?
explain extended properties
How can we determine what objects a user-defined function depends upon?
what is a self join? : Sql server database administration
What is tablesample?
What is the downside of using udf?
What is difference between global temporary tables and local temporary tables?
What are the differences between having and where clause.
How can you check the version of sql server?
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
What is difference between cte and view?
How do I list the available tables in a database I'm querying?