create sequence seq_name
   start with 1
   increment by 1
   maxvalue 999999
   nocycle
   cache 20;
create public synonym seq_name for owner.seq_name;
grant select on seq_name to joe_user;

##</code><code>##

insert into table 
    (seq_col, cola, colb, colc)
  values 
    (seq_name.NEXTVAL, 'data','moredata','otherdata')

##</code><code>##

insert into table 
  values 
    (seq_name.NEXTVAL, 'data','moredata','otherdata')