如何在Oracle中提交多条SQL语句？

SQL> SELECT * FROM table1;
SQL> INSERT INTO table2 VALUES (1, 'example');
SQL> UPDATE table3 SET column1 = 'value' WHERE column2 = 'condition';

SQL> BEGIN
  2    INSERT INTO table1 VALUES (1, 'example');
  3    UPDATE table2 SET column1 = 'value' WHERE column2 = 'condition';
  4    DELETE FROM table3 WHERE column4 = 'condition';
  5  END;
  6  /

SQL> DECLARE
  2    -- 声明变量
  3  BEGIN
  4    -- 执行SQL语句
  5    EXECUTE IMMEDIATE 'INSERT INTO table1 VALUES (1, ''example'')';
  6    EXECUTE IMMEDIATE 'UPDATE table2 SET column1 = ''value'' WHERE column2 = ''condition''';
  7    EXECUTE IMMEDIATE 'DELETE FROM table3 WHERE column4 = ''condition''';
  8  END;
  9  /