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 oracle and what are its different editions?
What is an oracle?
How to add another datafile to a tablespace?
What are transaction isolation levels supported by oracle?
How to rename an existing table?
What is a user account in oracle?
How to add a new column to an existing table in oracle?
How to connect to a local oracle 10g xe server?
How to list all tables in your schema?
What are the varoius components of physical database structure of oracle database?
How to create a new view in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain the blob datatype?
How to create a temporary table in oracle?
Can we call procedure inside function in oracle?