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 start an oracle instance?
Design database draw er diagram for a certain scenario ?
What is oracle latest version?
How to write a left outer join with the where clause in oracle?
How to select all columns of all rows from a table in oracle?
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
