What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
Answer Posted / 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 |
Post New Answer View All Answers
What are click through reports?
How to download and install the scaled-down database adventureworkslt?
what are different types of backups available in sql server? : Sql server database administration
How can you append an identity column to a temporary table?
Explain forward - only cursors?
Is truncate a dml command?
What is thr feature of change data capture?
What are the joins in sql server? : sql server database administration
How can you stop stored procedures from recompiling?
What command would you use to create an index?
What is the function of inner join?
How can you find out which stored procedures are recompiling?
What are the new features of sql server 2012 reporting service?
How to use user defined functions in expressions?
What are the database roles? : sql server security