Home » SQL & PL/SQL » Client Tools » Difference between DEFINE and VARIABLE (PL SQL)
icon6.gif  Difference between DEFINE and VARIABLE [message #289690] Tue, 25 December 2007 08:41 Go to next message
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.
Re: Difference between DEFINE and VARIABLE [message #289694 is a reply to message #289690] Tue, 25 December 2007 09:03 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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.
Re: Difference between DEFINE and VARIABLE [message #289695 is a reply to message #289690] Tue, 25 December 2007 09:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bind Variables
Defining Substitution Variables
Using Substitution Variables

Regards
Michel
Re: Difference between DEFINE and VARIABLE [message #290061 is a reply to message #289690] Thu, 27 December 2007 05:09 Go to previous message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

Thanks Littlefoot and Michel Cadot
Previous Topic: geting error when trying to connect to oracle
Next Topic: sqlplus table output
Goto Forum:
  


Current Time: Wed Dec 07 02:45:43 CST 2016

Total time taken to generate the page: 0.17261 seconds