Skip to Main Content
Forums

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!

DECLARE keyword in PL/SQL procedure

603591Feb 20 2008 — edited Feb 21 2008
I have seen PL/SQL blocks that start with a cursor definintion and some variable definitions, followed by a BEGIN statement, but that do not have a DECLARE keyword.

Is the DECLARE keyword optional?

TIA,

Far Farley
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2008
Added on Feb 20 2008
16 comments
4,199 views