What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 12153 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 are the dis_advantages of stored procedures, triggers, indexes?
What is an index in a database?
Can multiple columns be used in sql group by clause in ms sql server?
Explain alternate key, candidate key and composite key in sql server?
Explain system scalar functions?
Does windows server 2016 come with sql server?
How to view existing indexes on an given table using sys.indexes?
Explain left outer join and right outer join?
What are horizontal and vertical scaling?
What is an expensive query?
Explain what is it unwise to create wide clustered index keys?
How can I check that whether automatic statistic update is enabled or not?
What is an index in sql?
What is table-valued sub query?
What is updatable resultset?
