OraFAQ Forum: Client Tools » Difference between DEFINE and VARIABLE

Home » Other » Client Tools » Difference between DEFINE and VARIABLE (PL SQL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between DEFINE and VARIABLE [message #289690]

Tue, 25 December 2007 08:41

cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...

Junior Member

Let me know difference between DEFINE and VARIABLE when defining host / bind variables.
Thanks and Regards,
Suresh.

Report message to a moderator

Re: Difference between DEFINE and VARIABLE [message #289694 is a reply to message #289690]

Tue, 25 December 2007 09:03

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

DEFINE specifies a substitution variable and assigns a CHAR value to it, or lists the value and variable type of a single variable or all variables.

VARIABLE declares a bind variable that can be referenced in PL/SQL, or lists the current display characteristics for a single variable or all variables.

For more information, check the SQL*Plus User's Guide and Reference book.

Report message to a moderator