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 group by in sql?
What is plpgsql language?
How can you create an empty table from an existing table?
Why are sql stored procedures used?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Which is the correct statement about truncate and delete?
how to convert character strings to numeric values? : Sql dba
how to drop an existing table in mysql? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
Does execute immediate commit?
When you have to use a default "rollback to" savepoint of plvlog?
Explain the uses of database trigger.
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Can a primary key be a foreign key?
How does index help in query performance?