What are user defined stored procedures ?
Answer Posted / anbu
Stored procedures is like a simple PLSQL/instructions
programme which can perform desired operation to get the
exact output from the oracle server(if the DB is oracle).
The user defined stored proceture can be created by users
and they can use funtions,procedure and packages to get the
output from the database engine.
The next thing is they can call it at any part in the
main programme.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is attribute indicator in pl sql?
What is mdf ldf and ndf?
What is a sql profiler?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
how to fetch alternate records from a table? : Sql dba
what is 'mysqlshow'? : Sql dba
how many values can the set function of mysql take? : Sql dba
How do I install microsoft sql?
What is meaning of <> in sql?
what is auto increment? : Sql dba
how do you know the version of your mysql server? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
define sql delete statement ? : Sql dba
Explain the advantages and disadvantages of stored procedure?
What is a loop in sql?