Re: SQL*Plus and compound variables

From the manual

VAR[IABLE] [variable {NUMBER|CHAR|CHAR (n)|NCHAR |NCHAR (n)|VARCHAR2 (n)| NVARCHAR2 (n)
|CLOB|NCLOB|REFCURSOR}] If you don't have it, all manuals are online at http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA

ducatv <ducatv_at_tin.it> schreef in berichtnieuws 8goaaa$rkf$1_at_nslave2.tin.it...
> Is possible to declare a compound variable in SQL*Plus.
>
> For example:
> TYPE record (
> x NUMBER,
> y VARCHAR2)
>
> VARIABLE w record
>
> Thanks
>
>
Received on Sat May 27 2000 - 00:00:00 CDT