What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they.
- 5 Answers
- 12186 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / darshan shah
SP may return value or may not ,function always treturn
value.
SP cannot use in sselect statment or in sql stattment ,We
can use Function in any where in sql statment.
Packeage is set of statment,SP,Function Which run one by
one statment in that.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to return the date part only from a sql server datetime datatype?
What are indexes in ms sql server?
How can I track the changes or identify the latest insert-update-delete from a table?
How many full-text indexes can a table have?
What is the native system stored procedure to execute a command against all databases?
How to create a user to access a database in ms sql server using "create user" statements?
what is bit datatype? : Sql server database administration
What are the components of sql server service broker?
What is table-valued sub query?
How to replace given values with null using nullif()?
What is shrink log file?
What is a functions and types in sql server?
What Is Rdbms?
What is open database communication (odbc)?
Write an sql query to find first weekday of the month?
