Home » SQL & PL/SQL » SQL & PL/SQL » error in create sequence.
error in create sequence. [message #216928] Tue, 30 January 2007 22:34 Go to next message
chinmay_uce02
Messages: 11
Registered: January 2007
Junior Member
Hi all,
i am creating a sequence but it is showing the following error.


SQL>create sequence seqq minval1 start with 1 increment by 1;

ERROR at line 1:
ORA-00933: SQL command not properly ended

thanks in advance
chinmay
Re: error in create sequence. [message #216931 is a reply to message #216928] Tue, 30 January 2007 22:40 Go to previous messageGo to next message
chinmay_uce02
Messages: 11
Registered: January 2007
Junior Member
i got it
Re: error in create sequence. [message #216934 is a reply to message #216928] Tue, 30 January 2007 22:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
SQL> create sequence seqq
  2 increment by 1
  3 start with 1
  4 minvalue 1;

Sequence created.



http://www.psoug.org/reference/sequences.html
regards
Taj

[Updated on: Tue, 30 January 2007 23:00]

Report message to a moderator

Previous Topic: SQLPLUS command HELP!! Write data to Files
Next Topic: problem with trigger.
Goto Forum:
  


Current Time: Wed Dec 07 20:30:28 CST 2016

Total time taken to generate the page: 0.11483 seconds