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 limitation on the block size of pl/sql?
How can you save or place your msg in a table?
Can we insert in sql function?
What is count * in sql?
Types of cursor locks and explanation each of them ?
Are sql views compiled?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
what is cursor procedure
What is difference between select statement and cursor
What is oracle sql developer?
What are records give examples?
how can i read files from a pl/sq l program
Oracle (3259)
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)