Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 13354 Views
- IBM, I also Faced
- E-Mail Answers
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
Can two tables have the same primary key?
What is onf in normalization form?
How can you list all the columns in a database?
What do you understand by physical_only option in dbcc checkdb?
Why do we use non clustered index?
Explain what are page splits? : SQL Server Architecture
How to generate create table script on an existing table in ms sql server?
Do you know what is a trace frag? Where do we use it?
What do you mean by a dependent functionality in a build?
What is server-level principal?
What are the different SQL Server Versions you have worked on?
Explain Reporting Life Cycle?
What is a periodical index?
Define left outer join in sql server joins?
How to Insert multiple rows with a single insert statement?
