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
- 13129 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
What does normalization do to data?
How exceptions can be handled in sql server programming?
how would you troubleshoot blocking? : Sql server database administration
What are the disadvantages of merge replication?
What is sql profiler. What are the default templates with it? : sql server database administration
Are connections to sql server encrypted?
Where to find ntwdblib.dll version 2000.80.194.0?
How do you rename a table in sql server?
What are the advantages of passing name-value pairs as parameters?
What are synonyms?
Explain alternate key, candidate key and composite key in sql server?
Can you get second highest salary from the table?
What is the distinction amongst delete and truncate?
What is the difference between mysql and mysqli?
Explain transaction server implicit?
