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 string functions in sql?
Define commit, rollback and savepoint?
How delete all data from table in sql?
Is microsoft sql free?
What is cascade in sql?
What is pl sql package?
What is the best partition size for windows 10?
Is sql similar to python?
How many types of cursors are available in pl/sql?
How bulk collect improves performance?
How to change sql*plus system settings?
What are the limitations of sql express?
What are procedures used for?
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 is normalisation in sql?