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
How many columns can we include on clustered index ?
How to verify the port number of the sql server?
What are dml triggers and types of dml triggers?
Why do you want to join software field as you have done your BE in Electronics?
When would you use sql joins?
What happens when transaction log is full?
Describe in brief authentication modes in sql server.
What are the properties and different types of sub-queries?
What are the basic features of a trigger in ms sql server?
What is database white box testing?
How to recover from sql injection? : sql server security
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain the first normal form(1nf)?
How can we check the sql server version?
What is sql stored procedure?