Re: SQL*PLUS

From: Valery V. Tsekhmister <valery_tsekhmister_at_hotmail.com>
Date: Fri, 24 Jan 2003 15:57:12 +0300
Message-ID: <b0rgmg$aft$1_at_slim.sovintel.ru>


Hi !

You can notify sql*plus about this bind variable by doing the following, for example:

  • Here you define and assign value to your bind variable: var lines number begin :lines := 123;end; /* (or any plsql Óode) */ /
  • Here you re-bind this variable to sql*plus environment: col lines new_v lines select :lines lines from dual;
  • Then you simply invoke sql*plus SET command set linesize &lines
  • Then you can see recently set value show linesize

Regards !
Valery.

"MCLAUDE" <melanie.claude_at_conix.fr> wrote in message news:7f4951fa.0301240426.5ac9d7a4_at_posting.google.com...
> How, with SQL PLUS use a bind reference in order to define an
> environement variable ?
> set linesize :bind_variable
>
> Thanks
Received on Fri Jan 24 2003 - 13:57:12 CET

Original text of this message