What is the different between Stored Procedure and Procedure?

Answer Posted / k.deepthi

Yes,Store Procedure/Procedure are one and the same.We have
to Create Procedure and Compile it in Data base,once
compiled it will be stored and we can use the same when
ever required in various other Procedures.

Procedure Usually used to perform set of actions based on
conditions.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run pl/sql statements in sql*plus?

663


What is a database? Explain

687


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2078


What is difference between hql and native sql?

671


Can we use loop in sql?

627






Why do we use procedures in sql?

641


What is %s in sql?

657


How to rename a column in the output of sql query?

625


What is sql profiler in oracle?

661


Which constraints we can use while creating database in sql?

697


Explain what is a column in a table?

673


What is a primary key example?

601


What is bitemporal narrowing?

851


How can you tell the difference between an index and a view?

591


Explain the working of primary key?

720