Re: Use sequense in Create Table

You can use:

create table av as select 'x' "uid" from dual;

HTH "Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:cAaKa.11492$oU5.5160_at_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 Thu Jun 26 2003 - 10:19:48 CDT