Interested to Buy Any Domain ? << Click Here >> for more details...
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
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How are extents allocated to a segment?
How to create a stored function in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
When system tablespace is created?
Does oracle partitioning improve performance?
Explain the use of grant option in imp command.
What is the data type of dual table?
How to synchronize 2 schema's objects?
How to insert multiple rows with one insert statement in oracle?
How do you tell what your machine name is and what is its IP address?
How to load a large xml file?
How to start your 10g xe server from command line?
How many memory layers are in the oracle shared pool?
Explain implicit cursor.
