Answer Posted / rocky-455
1. Store procedure may or may not return a value. If we want to return a value then we need to pass the parameters like INPUT & OUTPUT parameters
2. It can allowed SELECT/INSERT/UPDATE/DELETE Statements. It can be change state of table.
3. It can call Functions, Views, and Procedures inside procedures.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use "for" statements in oracle?
How many categories of data types?
What is logical backup in oracle?
How to write numeric literals in oracle?
Does oracle charge for java?
What is bind variable in oracle 11g?
What are the various constraints used in oracle?
How to export several tables together?
What is the usage of control file in oracle?
please explain.. DB architecture ...
How to retrieve values from data fields in record variables?
How to use "if" statements on multiple conditions?
What is pragma autonomous transaction in oracle?
Design database draw er diagram for a certain scenario ?
What is a data dictionary and how can it be created?