what is difference between stored procedures and
application procedures,stored function and application
function?
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 |
What is the difference between nvl function, ifnull function, and isnull function?
what does it mean to have quoted_identifier on? : Sql dba
What is a file delimiter?
What has stored procedures in sql?
What is structural independence and why is it important?
how would you get the current date in mysql? : Sql dba
Mention what pl/sql package consists of?
How do you break a loop in pl sql?
What is an exception in pl/sql?
Do we need to rebuild index after truncate?
Is sqlite thread safe?
What are the different sql languages?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)