Home » SQL & PL/SQL » SQL & PL/SQL » how to generate sequence number?
how to generate sequence number? [message #1390] Thu, 25 April 2002 10:05 Go to next message
Mitra
Messages: 11
Registered: April 2002
Junior Member
I am new to Oracle and i like to know if Oracle database has the equivalent to Auto Increment Identity column generated by MSSQL Server?
Thanks for the help!
Mitra

Report message to a moderator

Re: how to generate sequence number? [message #1391 is a reply to message #1390] Thu, 25 April 2002 10:11 Go to previous message
Faisal
Messages: 16
Registered: November 2001
Junior Member
CREATE SEQUENCE (sequence name)
[[START WITH (start value no)]]
[[MAXVALUE (maximum value number)]] OR [[NO MAX VALUE]]

hope it helps
:-)

Report message to a moderator

Previous Topic: Code works but don't like extra burden when calling procedure.
Next Topic: varchar2 too long to read?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 27 17:56:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.