Re: SQL PLUS question

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. :-(

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

HTH,
Brian

On 26 Feb 2001 16:28:41 GMT, "jAnO!" <j.j.groot_at_kpn.com> wrote:

>Hello,
>
>Does anybody know the correct syntax (or wheter it's possible) for what i
>am trying to do. I want to fill a parameter with the result of a query, and
>i can't find anything regarding this in my reference guide. Since I'm
>restrected to usenet only I thought to ask it here.....
>
>I'm using Oracle7 Server Release 7.3.4.4.0 - Production
>With the distributed and parallel query options
>PL/SQL Release 2.3.4.4.0 - Production
>.......
>
>Thank's in advance
>
>Jan
>
>--
>begin BELGISCH-VIRUS.exe
> Mail me naar al je vrienden en formatteer daarna je harddisk!
>end
>
Received on Mon Feb 26 2001 - 10:55:34 CST