Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence question?
I tried before, but I failed to run this command.
The error message returns that " ORA-00933: SQL command not properly ended".
Does anyone know what problem is it?
Thanks a lot !
"Christine" <cfvigil_at_cs.com>
???????:d42fa30f.0207310852.1a9fecde_at_posting.google.com...
> "Andrew Wong" <andrew_at_i-cable.com> wrote in message
news:<ai727b$pfj1_at_rain.i-cable.com>...
> > Is it possible to create sequence like this.?
> >
> > CREATE SEQUENCE seq_emp ON emp.emp_id START WITH 1 MAXVALUE 99999999999
> > INCREMENT BY 1;
> >
> > emp is a table and emp_id is one of the column.
>
> Dear Andrew:
> Here is what the create sequence scripts look like in some of my
> database
> creation scripts.
>
> CREATE SEQUENCE SEQ_EMP ON EMP.EMP_ID MINVALUE 1 MAXVALUE
> 999999999999999999999999999
> INCREMENT BY 1 START WITH 1
>
> HTH
>
> Christine
Received on Thu Aug 01 2002 - 12:57:27 CDT