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


Please Help Members By Posting Answers For Below Questions

How many columns can we include on clustered index ?

681


How to verify the port number of the sql server?

722


What are dml triggers and types of dml triggers?

724


Why do you want to join software field as you have done your BE in Electronics?

1900


When would you use sql joins?

693


What happens when transaction log is full?

669


Describe in brief authentication modes in sql server.

735


What are the properties and different types of sub-queries?

774


What are the basic features of a trigger in ms sql server?

799


What is database white box testing?

859


How to recover from sql injection? : sql server security

711


When I run the sql server 2000 setup, it just hangs. What do I do?

816


Explain the first normal form(1nf)?

756


How can we check the sql server version?

747


What is sql stored procedure?

797