Re: SQL PLUS question

From: jAnO! <j.j.groot_at_kpn.com>
Date: 27 Feb 2001 07:34:46 GMT
Message-ID: <01c0a08f$c264d750$142b15ac@TONTW0102131521>

Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> schreef in artikel <3a9a88cf.266100765_at_news.alt.net>...
> You can declare a variable in SQLPLUS with the variable command. The
> PRINT command will show you what the variable equals.
>
> VARIABLE MyVar VARCHAR2
> PRINT MyVar
>
> And do not use ERROR as a variable. It won't work. I found out the
> hard way. :-(

Thank you, but i want to know how to fill that parameter with the result of a query....

> It is all explained in the "SQL*Plus User's Guide and Reference",
> Chapter 3, Subtitle, "Using Bind Variables".
>

I can't acces the WWW from here so i can't look it up.....

> HTH,
> Brian
>
Received on Tue Feb 27 2001 - 01:34:46 CST