Oracle PL-SQL Question:
Download Questions PDF

What is difference b/w 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.

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
Explian rowid, rownum?what are the psoducolumns we have?How to order siblings in oracle hierarchy queries?