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 |
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is a heap in sql?
What is the usage of the distinct keyword?
How to assign sql query results to pl sql variables?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How can a pl sql block be executed?
how to convert dates to character strings? : Sql dba
Name the tables where characteristics of Package, procedure and functions are stored ?
In testing where do we use sql language and how it helps in testing?
what is the difference between stored procedure and packaged procedure
what are pl/sql collections?
4 Answers JPMorgan Chase, Oracle,
What is sql data?