Re: Newbie question: How to add auto number...

Jack,
You need to Create a Sequence (which can generate Unique Numbers starting at a value specified by you, increment by a specified value, grow to a Very big Number or Cycle at a Specified Value ) .

The command is
>Create sequence <SEQ_NAME>

increment by <integer>
start with <integer>
maxvalue <integer> ...;

Then while inserting ,you can use it like

Insert into <table_name> values(SEQ_NAME.nextval,...);

Hope this helps

-Thiru

Jack Chen wrote:

> Hi,
>
> Sorry for asking this question, this is my first day on Oracle.
>
> How to make the first column(such as 'User_ID')add an auto number, it was
> very easy in Access and SQL.
>
> Thanks
>
> Jack
Received on Wed Sep 15 1999 - 14:46:31 CDT