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
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 3049Received on Sat Nov 30 1996 - 00:00:00 CET