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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,308 views