what are stored procedures?

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


Please Help Members By Posting Answers For Below Questions

What is oracle and what are its different editions?

811


What is an oracle?

770


How to add another datafile to a tablespace?

833


What are transaction isolation levels supported by oracle?

791


How to rename an existing table?

808


What is a user account in oracle?

875


How to add a new column to an existing table in oracle?

871


How to connect to a local oracle 10g xe server?

754


How to list all tables in your schema?

810


What are the varoius components of physical database structure of oracle database?

776


How to create a new view in oracle?

849


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

1789


Explain the blob datatype?

822


How to create a temporary table in oracle?

957


Can we call procedure inside function in oracle?

820