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 are the differences between char and varchar2 in oracle?
What is the difference between a primary key & a unique key?
Can we store pictures in the database and if so, how it can be done?
What are the ansi data types supported in oracle?
Does oracle database need java?
How does Oracle guarantee data integrity of data changes?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Is there a function to split a string in plsql?
What is an oracle and why it is used?
How can we force the database to use the user specified rollback segment?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is an oracle database table?
How to create a single index for multiple columns?
What do you understand by a database object? Can you list a few of them?
How to use "if" statements on multiple conditions?