SQLPlus -> Define

[Thomas Kindermann]

Hi everyone,

i have a question about the define statement in sqlplus
(i try to migrate my svrmgrl-scripts to sqlplus):

in my script a produce a new script with sql commands (no news ;-) )
when i use the define statement to define a variable then the
automatic replacement produce a 'old value-new value' output in my new
script (bad....)

How can i suppress this ?
(something like HEADING OFF) ?

Thanks in advance

Thomas Kindermann
Oracle DB-Admin

[mcstock]

set verify off

"Thomas Kindermann" <tkinder@gmx.de> wrote in message
news:3faa7425$0$50543$45beb828@newscene.com... Hi everyone, i have a question about the define statement in sqlplus (i try to migrate my svrmgrl-scripts to sqlplus): in my script a produce a new script with sql commands (no news ;-) ) when i use the define statement to define a variable then the automatic replacement produce a 'old value-new value' output in my new script (bad....) How can i suppress this ? (something like HEADING OFF) ? Thanks in advance Thomas Kindermann Oracle DB-Admin

[Thomas Kindermann]

Thanks

thomas
"mcstock" <mcstockspamplug@spamdamenquery.com> schrieb im Newsbeitrag
news:OOydnbIV6OJ56zeiRVn-sg@comcast.com... set verify off "Thomas Kindermann" <tkinder@gmx.de> wrote in message news:3faa7425$0$50543$45beb828@newscene.com... Hi everyone, i have a question about the define statement in sqlplus (i try to migrate my svrmgrl-scripts to sqlplus): in my script a produce a new script with sql commands (no news ;-) ) when i use the define statement to define a variable then the automatic replacement produce a 'old value-new value' output in my new script (bad....) How can i suppress this ? (something like HEADING OFF) ? Thanks in advance Thomas Kindermann Oracle DB-Admin