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>
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