Tuesday, June 14, 2016

Oracle utl_file create file sample

SQL> CREATE DIRECTORY dump_dir AS '/u01/app/oracle/dump';

 
SQL>
DECLARE
  f1 UTL_FILE.FILE_TYPE;
BEGIN
  f1:= UTL_FILE.FOPEN('test_dir', 'test_file.txt', 'W');
  UTL_FILE.PUTF(f1, 'Writing');
  UTL_FILE.FCLOSE(f1);
END;
/