可以考虑使用外部表。前提是各个文本文件的内容格式相同。在PLSQL中使用动态sql,执行删除、创建外部表的语句。给你一个例子吧:在Oracle9i中,使用 External Table可以在线地查看alter.log文件内容,从而进行某些查询、工作调度来监控错误。假设日志文件位置为 C:\oracle\admin\VILA\bdump\alert_vila.logCREATE OR REPLACE DIRECTORY ALERT_DIR AS 'C:\oracle\admin\VILA\bdump';CREATE TABLE ALERT_LOG ( ID NUMBER(10), CONTENT VARCHAR2(2000) )ORGANIZATION EXTERNAL( TYPE ORACLE_LOADER DEFAULT DIRECTORY ALERT_DIR ACCESS PARAMETERS( RECORDS DELIMITED BY NEWLINE NOBADFILE NOLOGFILE NODISCARDFILE FIELDS TERMINATED BY "STR X'7C0D0A'" MISSING FIELD VALUES ARE NULL (ID RECNUM,CONTENT) )LOCATION('alert_vila.log') )PARALLEL 5 REJECT LIMIT UNLIMITED;SELECT COUNT(*) FROM ALERT_LOG;类似的内容上网查查,祝你成功!
ID NUMBER(10),
CONTENT VARCHAR2(2000)
)ORGANIZATION EXTERNAL(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY ALERT_DIR
ACCESS PARAMETERS(
RECORDS DELIMITED BY NEWLINE NOBADFILE NOLOGFILE NODISCARDFILE
FIELDS TERMINATED BY "STR X'7C0D0A'" MISSING FIELD VALUES ARE NULL (ID RECNUM,CONTENT)
)LOCATION('alert_vila.log')
)PARALLEL 5 REJECT LIMIT UNLIMITED;SELECT COUNT(*) FROM ALERT_LOG;类似的内容上网查查,祝你成功!