+ Reply to Thread
Results 1 to 7 of 7

SQLPlus -> Define

  1. SQLPlus -> Define

    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



  2. Re: SQLPlus -> Define

    set verify off

    "Thomas Kindermann" 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
    >
    >




  3. Re: SQLPlus -> Define

    set verify off

    "Thomas Kindermann" 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
    >
    >




  4. Re: SQLPlus -> Define

    set verify off

    "Thomas Kindermann" 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
    >
    >




  5. Re: SQLPlus -> Define

    Thanks

    thomas
    "mcstock" schrieb im Newsbeitrag
    news:OOydnbIV6OJ56zeiRVn-sg@comcast.com...
    > set verify off
    >
    > "Thomas Kindermann" 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
    > >
    > >

    >
    >




  6. Re: SQLPlus -> Define

    Thanks

    thomas
    "mcstock" schrieb im Newsbeitrag
    news:OOydnbIV6OJ56zeiRVn-sg@comcast.com...
    > set verify off
    >
    > "Thomas Kindermann" 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
    > >
    > >

    >
    >




  7. Re: SQLPlus -> Define

    Thanks

    thomas
    "mcstock" schrieb im Newsbeitrag
    news:OOydnbIV6OJ56zeiRVn-sg@comcast.com...
    > set verify off
    >
    > "Thomas Kindermann" 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
    > >
    > >

    >
    >




+ Reply to Thread