日期:2014-05-17 浏览次数:20854 次
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;
/