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 are the subsets of sql?
define join and explain different type of joins? : Sql dba
What is sql deadlock?
What is the difference between left join and right join?
What is data profiling in sql?
What is use of package in pl sql?
What do we need to check in database testing?
What is the difference between subquery and correlated query?
What is scope of pl sql developer in future?
What is the reports view in oracle sql developer?
Why do we go for stored procedures?
What is the use of sql trace?
Why do we use joins in sql?
Is a view faster than a stored procedure?
What is error ora-01000: maximum open cursors exceeded