Re: Use sequense in Create Table

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Wed, 25 Jun 2003 05:39:20 GMT
Message-ID: <cAaKa.11492$oU5.5160@news02.roc.ny.frontiernet.net>

"SouthVN" <nphuongtt_at_yahoo.com> wrote in message news:ee28214c.0306242043.e1c87dd_at_posting.google.com...
> 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
>

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 Received on Wed Jun 25 2003 - 00:39:20 CDT