Home > Articles > Data > Oracle

  • Print
  • + Share This
From the author of

Informix: SERIAL Datatype

Informix handles sequential numbers in the CREATE TABLE statement with a special SERIAL datatype. Specifying 0 for the SERIAL column during INSERT makes Informix assign the next sequential number.

Informix

create table testseq
(num serial not null,
name varchar(10) not null)

Table created.
insert into testseq
values ( 0, 'Amir')
insert into testseq
values ( 0, 'Marge')
insert into testseq
values ( 0, 'Tri')

select *
from testseq

    num name    
     1 Amir   
     2 Marge   
     3 Tri 
[3 rows]
  • + Share This
  • 🔖 Save To Your Account