drop table umfrage purge
/

drop sequence seq_umfrage
/

create table umfrage(
  "ID"            number(10),
  "ALTER"         number(3),
  "MTL_EINKOMMEN" number(6),
  "STIMME_ZU"     char(1)
)
/

create sequence seq_umfrage
/

create or replace trigger tr_umfrage_id
before insert on umfrage
for each row
begin
  select seq_umfrage.nextval into :new.id from dual;
end;
/
sho err

insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (33,1723,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (28,2000,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (29,2500,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (50,6000,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (55,1500,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (35,4000,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (25,2900,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (28,3100,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (31,1566,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (57,2400,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (60,5000,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (61,7500,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (51,4000,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (47,3000,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (56,1400,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (39,2300,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (55,2100,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (75,1000,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (76,1500,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (81,5400,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (44,2300,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (29,3000,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (34,4500,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (36,2300,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (21,1000,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (66,2300,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (34,2300,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (33,2723,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (68,2000,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (29,2900,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (50,6300,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (55,1200,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (35,4700,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (25,2400,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (28,2550,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (31,1731,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (57,4312,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (60,5120,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (61,5230,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (51,4600,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (47,4500,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (56,1400,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (39,1890,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (55,2910,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (75,2180,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (76,1240,'N');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (81,8950,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (44,2340,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (29,3220,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (34,5623,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (36,1230,'Y');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (21,1231,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (66,3220,'');
insert into umfrage ("ALTER","MTL_EINKOMMEN","STIMME_ZU") values (34,2320,'Y');

commit
/