Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure Vs Stored Procedure

GTS (DBA)Jul 30 2013 — edited Jul 31 2013

Hello Good Morning all ;

I am getting confused with Procedure Vs Stored Procedure.

Please say which  is valid one ?

Procedure is  a block of PL/SQL code , it  never stored in database.

Procedure is  a block of PL/SQL code , it  is named  and  stored within  the database.

Stored procedure  is  block of PL/SQL code  it  is named  and  stored within  the database.

someone saying procedure concepts from Oracle for PL/SQL . Stored  procedure concept from  microsoft for SQL SERVER.


Thanks all ;





This post has been answered by Frank Kulash on Jul 30 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2013
Added on Jul 30 2013
20 comments
8,656 views