CREATE TABLE TESTKFZ (Kennz, ANSCH, Marke, Modell) AS
SELECT       KENNZEICHEN, ANSCHDAT,MARKE, MODELL
FROM         FUHRPARK;

INSERT INTO TESTKFZ (Kennz, ANSCH, Marke, Modell)
    VALUES('M-BB-5298','10.08.2009','ROVER','45');

INSERT INTO TESTKFZ
    VALUES('S-HH-344','05.10.2010','Ferrari','Testarossa');

INSERT INTO TESTKFZ (Kennz, ANSCH, Marke, Modell)
    VALUES(&Kennz, &ANSCH, &Marke, &Modell);

ALTER TABLE TESTKFZ
        ADD (UNFALL VARCHAR2(4) DEFAULT 'NEIN');

UPDATE TESTKFZ
SET UNFALL = 'JA'
WHERE Marke ='Ferrari' OR Marke ='Mini';

COMMIT TESTKFZ;


DELETE
FROM TestKfz
WHERE Kenz ='M-BB-5298'
SAVEPOINT save1;

DELETE
FROM TestKfz
WHERE Kenz =S-HH-344'
SAVEPOINT save2;

DELETE
FROM TestKfz
WHERE Kenz ='HH-SV-532'
SAVEPOINT save3;



ROLLBACK TO save1;
ROLLBACK TO save2;
ROLLBACK TO save3;