Re: Table Design!

johnparcels_at_gmail.com wrote:
> Hi All
> I have a table that has 2 columns,ColID--ID Column and text column.
> The ColID Column is the
> Primary Key for the table. I want to insert only text values in this
> table. I do not have ColID values, but want to insert numbers in
> ascending order. How could I do it.
> Should I necessarily convert the ColID to an Auto Number?
>
> Thank's alot.
>
> JohnP.

Oracle has no concept of autonumbering. Are you mistaking Oracle for a Microsoft product?

And when you respond include the version number.

BTW: Inserting in ascending order is meaningless and a concept that does not belong in a relational database. What is the business rule you are applying and why does it exist.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)