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

Answer Posted / pratap557

We cannot write DML in Function whereas in SPs we can

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What to perform pattern match with the like operator?

487


How do I create a stored procedure in dbml?

517


What are rows and columns?

524


What is replace and stuff function in sql server?

567


What is the difference between primary key and unique constraints?

516






What do you mean by data manipulation language?

597


Can sql servers linked to other servers like oracle?

548


What is the difference between SQL notification and SQL invalidation?

592


Should you normalize audio?

531


What is compression - row-level and page-level compression?

535


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

536


How can I change procedure name in sql server?

541


What do you mean by table and field in sql?

558


What is sql profiler. What are the default templates with it? : sql server database administration

523


Show Practically Sql Server Views are updatable?

594