Help on identity column

If somebody could help a Sybase user, I'd appreciate it. I want to create a table in Oracle 8 where the numeric primary key has the eqivalent of Sybase's "identity" property. That is, the system automatically maintains a sequential counter. Eg, in Sybase:

create table my_table (
  key_col numeric(10) identity,
  non_key_col char(10)
)

With the "identity" property, Sybase will automatically generate the value for key_col, using 1, 2, 3, etc.

How is this done in Oracle 8?

Thanks,

Larry Coon
lmcoon_at_home.com Received on Fri Dec 24 1999 - 12:59:04 CST