Use sequense in Create Table

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 Received on Tue Jun 24 2003 - 23:43:45 CDT