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
- 13183 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
What happens if null values are involved in arithmetic operations?
How many types of the database links?
Does partitioning improve performance?
What is the largest component inside a field?
How do I view a script in sql server?
How many categories of functions based their return modes?
what are user defined datatypes? : Sql server database administration
Can a synonym name of a table be used instead of a table name in a select statement?
How do I open a .db file?
Explain view in sql server?
List the data types available in mssql?
What are the advantages of user defined function?
What is system stored procedures?
What command is used to rename the database?
List some advantages and disadvantages of stored procedure?
