Default sequence number

Is it possible in Oracle to have a sequence number generated and inserted into a table as a default, like in Sybase?

  In Sybase:
  Create tablename (
   ID int IDENTITY(1,1),
   col1 varchar(10))
   go
  Insert tablename (col1) values ('Hello')   go
  Insert tablename (col1) values ('Howdy')   go

  then table will be like this:

       ID    col1
       ==========
        1    Hello
        2    Howdy

Can Oracle do that without using sequence.NEXTVAL insertion? Thanks,

-Leslie Received on Sat Oct 26 1996 - 00:00:00 CEST