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 add a new column to an existing table with a default value?
Explain overloading. Can functions be overloaded?
How can I get column names from a table in oracle?
What is Library Cache in Oracle?
What is a trigger oracle?
How to add another datafile to a tablespace?
What is logical backup in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to sort the query output in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Difference between varchar and varchar2 data types?
How to enter a new row into a table interactively?
How to update values on multiple rows in oracle?
How to build data dictionary view an new database?
How to define a data field as not null?