what is difference between stored procedures and
application procedures,stored function and application
function?



what is difference between stored procedures and application procedures,stored function and appli..

Answer / swapna

stored procedures are subprogrammes stored in the database
and can be called & execute multiple times where in an
application procedure is the one being used for a
particular application same is the way for function.

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  


What is a heap in sql?

0 Answers  


What is the usage of the distinct keyword?

0 Answers  


How to assign sql query results to pl sql variables?

0 Answers  


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  






How can a pl sql block be executed?

0 Answers  


how to convert dates to character strings? : Sql dba

0 Answers  


Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  


In testing where do we use sql language and how it helps in testing?

2 Answers  


what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,


what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,


What is sql data?

0 Answers  


Categories