mschaefer@9661: --Neues Feld vegetation_type.de_name
mschaefer@9661: 
mschaefer@9661: SET AUTOCOMMIT ON;
mschaefer@9661: 
mschaefer@9661: ALTER TABLE vegetation_type ADD (de_name VARCHAR2(256));
mschaefer@9661: 
mschaefer@9661: UPDATE vegetation_type SET de_name='Zonaler Wald' WHERE id=1;
mschaefer@9661: UPDATE vegetation_type SET de_name='Hartholzaue, trocken' WHERE id=2;
mschaefer@9661: UPDATE vegetation_type SET de_name='Hartholzaue, feucht' WHERE id=3;
mschaefer@9661: UPDATE vegetation_type SET de_name='Silberweidenwald' WHERE id=4;
mschaefer@9662: UPDATE vegetation_type SET de_name='Weidengeb'||CHR(252 USING NCHAR_CS)||'sch' WHERE id=5;
mschaefer@9662: UPDATE vegetation_type SET de_name='Uferr'||CHR(246 USING NCHAR_CS)||'hricht' WHERE id=6;
mschaefer@9661: UPDATE vegetation_type SET de_name='Uferpioniere' WHERE id=7;
mschaefer@9661: UPDATE vegetation_type SET de_name='vegetationslos' WHERE id=8;
mschaefer@9662: UPDATE vegetation_type SET de_name='Wasserfl'||CHR(228 USING NCHAR_CS)||'che' WHERE id=9;
mschaefer@9661: 
mschaefer@9661: ALTER TABLE vegetation_type MODIFY (de_name NOT NULL);
mschaefer@9661: 
mschaefer@9661: COMMIT;