指定要插入值的列。试试下面。

BEGIN
   INSERT INTO TABLE1 (COL1,
                       COL2,
                       COL3,
                       COL4,
                       COL5,
                       COL6,
                       COL7)
        VALUES (27,
                TO_DATE ('19-Jun-2018 05:47', 'DD-MON-YYYY HH24:MI'),
                '622222222222',
                167,
                15454015,
                '335218',
                '5623125454');

   INSERT INTO TABLE2 (COL1, COL2, COL3)
           VALUES (
                     '145218',
                     TO_DATE ('19-Jun-2018 05:47', 'DD-MON-YYYY HH24:MI'),
                     ADD_MONTHS (
                        TO_DATE ('19-Jun-2018 05:47', 'DD-MON-YYYY HH24:MI'),
                        1));
COMMIT;

END;
/

如果您使用的是纯sql，那么oraclesql中就没有begintransaction语句（beginispl/sql关键字仅用于启动pl/sql块）。
事务从数据库中的第一次写入开始，以提交或回滚结束。
例子：

TEST@DB0>truncate table t1;

Table truncated.

TEST@DB0>truncate table t2;

Table truncated.

TEST@DB0>insert into t1 values(1, 'ONE');

1 row created.

TEST@DB0>insert into t2 values(2, 'TWO');

1 row created.

TEST@DB0>rollback;

Rollback complete.

TEST@DB0>select * from t1;

no rows selected

TEST@DB0>select * from t2;

no rows selected

TEST@DB0>insert into t1 values(1, 'ONE');

1 row created.

TEST@DB0>insert into t2 values(2, 'TWO');

1 row created.

TEST@DB0>commit;

Commit complete.

TEST@DB0>select * from t1;

    X1 Y1
---------- ----------
     1 ONE

TEST@DB0>select * from t2;

    X2 Y2
---------- ----------
     2 TWO

TEST@DB0>