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
What is the fastest query method to fetch data from the table?
Write a trigger example in oracle?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is BBED in Oracle?
Can you assign multiple query result rows to a variable?
How can I introduce multiple conditions in like operator?
What are the benefits of ordbms?
Can select statements be used on views in oracle?
What is a dead lock in oracle?
Is it possible to split the print reviewer into more than one region ?
How to find the duplicate rows count from employees table in oracle?
What do you know about normalization? Explain in detail?
what is the difference between functional dependecy and multilevel dependency?
What to do if the binary spfile is wrong for the default instance?
What is pragma autonomous transaction in oracle?
