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!

declaring variables

608286Nov 22 2007 — edited Nov 22 2007
we can declare variables in many ways in Oracle 9i, like
1) using DEFINE <identifier>
2) using VARIABLE <identifier>
3) using <identifier> datatype

What is the difference between these ways, and when do we prefer one method over other?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2007
Added on Nov 22 2007
2 comments
408 views