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
- 13398 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / scorpio.mishra
1->stored procedure can not be written as a column name but
function can be written as a column name
2->result set of stored procedure can not be used in
joining tables but table return by function can be used in
joins
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Is BCNF better than 2NF & 3NF? Why?
Describe the functionalities that views support.
Can we add an identity column to decimal datatype?
How many types of objects are there?
How many databases Microsoft SQL server provides?
What is view in sql?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?
What is normalization process?
What is the report builder?
Write a sql query to display the current date?
What are the transaction properties?
What do you mean by data manipulation language?
How to create a ddl trigger using "create trigger" statements?
What is an indexing strategy?
