Create table xyz ( abc (VARCHAR2(64)) NOT NULL def (VARCHAR2(150)) NOT NULL CONSTRAINT xyz_pk PRIMARY KEY (acb)); insert into xyz ('a:100','sa00230'); insert into xyz('a:1000','sa04514'); insert into xyz ('a:10000','a04010'); insert into xyz ('a:10000','a04012');