Re: Parameter Passing using Batch Files and SQLPlus

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 3 Oct 1999 11:21:01 -0300
Message-ID: <utKJ3.8972$xJ4.430393@newscontent-01.sprint.ca>

SQL> column user new_value x
SQL> select user from dual;

USER

---

SCOTT SQL> prompt &&x
SCOTT
SQL> @next.sql &&x

Mark Malakanov
DBA
Sapience, Toronto

<narayana_ck_at_my-deja.com> wrote in message news:7t30ke$clk$1_at_nnrp1.deja.com...
> Platform: NT
> Database: Oracle7.3.4 and above
>
> Is there a way i could have a sql script get a value from the database
> and set an environment variable to that value, so that my batch file
> can utilize it to pass it as an parameter or argument to other
> applications and sql scripts.
>
> thanks
> ck
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 03 1999 - 09:21:01 CDT