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

Explain a checkpoint?

771


Why do we use sql limitations? Which constraints can we use while making a database in sql?

745


What is policy management?

735


what exactly sql injuction.how to overcome.....

2249


What is Lock table in SQL?

1190


How to copy the tables, schema and views from one sql server to another?

741


What are diverse clauses that form a part of sql?

800


Define constraints and give an example of their use?

740


How to make a remote connection in a database?

709


What is model database? : SQL Server Architecture

766


Explain identity in sql server?

722


What does it mean to invest in the index?

701


Differentiate between delete and truncate.

750


Explain powershell included in sql server 2008?

770


What is a sql join?

752