Re: Another Script Prob..

On 11 Jun 2005 20:56:57 -0700, "Arijit Chatterjee" <arijitchatterjee123_at_yahoo.co.in> wrote:

>
>
>Hi IANAL_VISTA,
>I am aware of PL/SQL code but variable declaration is not taking place
>in the script.I followed your link also.
>> http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/toc.htm
>-----------------------------------------------
>Supose I am trying
>Accept Var Prompt 'Insert Table Name:'
>select col1 into var2(Not define) from &var where col='1'
>-----------------------------------------------
>My qustion is how to declare this var2 variable.Please guide me..
>Thanks in advance
>Reg
>Arijit Chatterjee

Just RTFM and look up the VARIABLE command.

--
Sybrand Bakker, Senior Oracle DBA