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
- 13581 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
Do you know what are various aggregate functions that are available?
How to see existing views in ms sql server?
what is the difference between Tabular and Matrix report?
Do you know what is user defined datatypes and when you should go for them?
How to view existing indexes on an given table using sys.indexes?
Explain some stored procedure creating best practices or guidelines?
what are constraints? Explain different types of constraints? : Sql server database administration
What are the restrictions while creating batches in sql server?
what's the information that can be stored inside a bit column? : Sql server database administration
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How does normalization work?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is read committed?
Explain following error properties?
How can I add Reporting Services reports to my application?
