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

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