sqlplus username/password@database

CREATE TABLE sql_import_result (
  line_number NUMBER,
  statement VARCHAR2(4000),
  result VARCHAR2(4000)
);

SET SQLBLANKLINES ON
SET ECHO ON
SET FEEDBACK ON
SET TIMING ON

-- 导入SQL文件
@path/to/sql/file.sql

-- 将SQL语句和结果插入到新表中
DECLARE
  line_num NUMBER := 1;
  stmt VARCHAR2(4000);
  stmt_result VARCHAR2(4000);
BEGIN
  FOR c IN (SELECT DISTINCT l.line#, l.text
            FROM sys.dba_source s, sys.ku$_source_line l
            WHERE s.obj# = (SELECT object_id
                            FROM sys.dba_objects
                            WHERE object_name = 'sql_import_result')
            AND s.source# = l.source#)
  LOOP
    stmt := c.text;
    BEGIN
      EXECUTE IMMEDIATE stmt;
      stmt_result := 'SUCCESS';
    EXCEPTION
      WHEN OTHERS THEN
        stmt_result := 'ERROR: ' || SQLERRM;
    END;

    INSERT INTO sql_import_result VALUES (line_num, stmt, stmt_result);
    line_num := line_num + 1;
  END LOOP;
END;
/

-- 查询导入结果
SELECT * FROM sql_import_result;