日期:2014-05-17 浏览次数:20741 次
create or replace directory ddd as 'C:\'; GRANT READ,WRITE ON DIRECTORY ddd TO scott; conn scott/tiger; DECLARE V_FILE UTL_FILE.FILE_TYPE; V_BUFFER VARCHAR2(32767); BEGIN V_FILE:=UTL_FILE.FOPEN('DDD','test.txt','W',32767); V_BUFFER := 'hello!'; UTL_FILE.PUT_LINE(V_FILE,V_BUFFER); UTL_FILE.FCLOSE(V_FILE); END; /