Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Another Script Prob..
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message de
news:ltgna11asvfpnt252kuea8cfpe8pta2gp3_at_4ax.com...
| 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
And the FM is:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/toc.htm
Regards
Michel Cadot
Received on Sun Jun 12 2005 - 02:05:34 CDT