Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sequence question?
Yes, you SQL command is not properly ended.
Jim
"Andrew Wong" <andrew_at_i-cable.com> wrote in message
news:aibsqm$t4r1_at_rain.i-cable.com...
> 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 - 20:53:52 CDT