In Oracle 9.20.1.0, there is a error in " autoUid.nextval uid"

this is statement SQL:

create table AAA as
( select autoUid.nextval uid , makh, makh urs from thdt_tbt_20030401
where makh<='0117650'
)

--> The following error has occurred:

ORA-00923: FROM keyword not found where expected


That proplem is I want to create ALIAS for autoUid.nextval but
happended that error.

All Oracle expert !
Please help me !, thanks very much

"SouthVN" <nphuongtt (AT) yahoo (DOT) com> wrote


Problem is not your sequence .... UID is a reserved word in oracle.
see v$reserved_words for the list.

create table av as select 'x' uid from dual;
create table av as select 'x' uid from dual
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

change your alias from uid to something like user_id or whatever!

HTH

Anurag