Re: HELP:Can you define variable on SQL*Plus prompts.

From: Hui, Kwok Miu <huikomix_at_dt.com.hk>
Date: 1996/11/30
Message-ID: <32A09EF6.69F7_at_dt.com.hk>#1/1


STri wrote:

> I have a query regarding creating variable in SQL command.
> Cn I say some thing like
> SELECT define x=max(value) from XYZ.
>
> OR any other way to define variable in SQL command.

Above is wrong in syntax. IN sql*plus, you might use:

variable x number;
select max(column) into &x from XYZ;

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Oracle DBA & Unix Administrator      Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049
Received on Sat Nov 30 1996 - 00:00:00 CET

Original text of this message