Answer Posted / rajesh
stored procedure is a named pl/sql block which accept some
parameter and performs some action....and its a one time
compilation....
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why procedure is used in sql?
What problem one might face while writing log information to a data-base table in pl/sql?
What is the difference between delete and truncate commands?
Explain the difference between triggers and constraints?
What are the types of optimization?
Is ms sql traffic encrypted?
Can we join more than 2 tables in sql?
What is union, minus and interact commands?
What is sql not null constraint?
Can we use pl sql in sql server?
What are the two different parts of the pl/sql packages?
What is the use of sql trace?
What is Histogram?
Why do we use cursors?
What are the indexing methods?