Re: A proper FAQ - Wish fulfillment

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in news:3e6c9546$0$225$ed9e5944_at_reading.news.pipex.net:

> b) There is no autoincrementing datatype in Oracle. You need to create a
> sequence and a before insert row level trigger. For example
>
> create table t(id number,description varchar2(50));
>
> create sequence seq_t start with 1 increment by 1 cache 50;
>
> create trigger trg_i_t
> before insert on t
> for each row
> begin
> select seq_t.nextval into :new.id from dual;
> end;
> /

• or -
  • without using a trigger:

INSERT INTO t SELECT seq_t.nextval, 'hola!' FROM DUAL;

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com