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
What is difference between group by and partition by?
The select into statement is most often used to create backup copies of tables or for archiving records?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are the sql aggregate functions?
what is the syntax used for partition in tsql? : Transact sql
What are the triggers associated with image items?
What is a heap in sql?
Is sql scripting language?
Explain the difference in execution of triggers and stored procedures?
Explain what is an index?
How does pl sql work?
Explain about various levels of constraint.
What is sql indexing?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Does oracle use sql?