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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a primary key? Explain

535


What is a native sql query?

488


What are the two virtual tables available at the time of database trigger execution?

627


Why left join is used in sql?

514


What is output spooling in sql*plus?

544






How to take user input in pl sql?

696


list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

505


What is secondary key?

506


Can we create index on primary key?

520


Difference between truncate, delete and drop commands?

552


How many sql statements are used? Define them.

571


Which is better stored procedure or query?

541


Which is better trigger or stored procedure?

494


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1634


What is sql constant?

501