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
How to run pl/sql statements in sql*plus?
What is a database? Explain
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..
What is difference between hql and native sql?
Can we use loop in sql?
Why do we use procedures in sql?
What is %s in sql?
How to rename a column in the output of sql query?
What is sql profiler in oracle?
Which constraints we can use while creating database in sql?
Explain what is a column in a table?
What is a primary key example?
What is bitemporal narrowing?
How can you tell the difference between an index and a view?
Explain the working of primary key?