InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Difference Between Stored Procedures And Application Procedures, Stored Function And Application Function? |
|
Answer» Stored procedures are subprogrammes stored in the database and can be CALLED &executee multiple times wherein an application procedure is the one being USED for a particular application same is the WAY for function. Both can be executed any NUMBER of times. Only DIFFERENCE is that stored procedures / functions are stored in database in complied format while the application procedures/functions are not in precomplied format and at run time has to be compiled. Stored procedures are subprogrammes stored in the database and can be called &executee multiple times wherein an application procedure is the one being used for a particular application same is the way for function. Both can be executed any number of times. Only difference is that stored procedures / functions are stored in database in complied format while the application procedures/functions are not in precomplied format and at run time has to be compiled. |
|