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 log shipping? : Sql dba
Which version of sql do I have?
What is triggering circuit?
what is the syntax for using sql_variant_property? : Transact sql
How do I truncate a word?
Does truncate require commit?
What is a procedure in pl sql?
What is parallel hint?
Can primary key be changed?
How do you update sql?
Explain the difference between sql and mysql.
List and explain the different types of join clauses supported in ansi-standard sql?
What is sql indexing?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is an alias command? : Sql dba