User Tools

Site Tools


kurs:write_to_file_utl_file

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

kurs:write_to_file_utl_file [2010/05/27 14:55]
mh
kurs:write_to_file_utl_file [2014/09/10 21:22]
Line 1: Line 1:
-<​code>​ 
-create directory data_dir as '​c:​\data';​ 
-grant read, write on directory data_dir to public; 
-</​code>​ 
  
-<​code>​ 
-PROCEDURE WRITE_TO_FILE 
-    is 
-     ​v_filehandle utl_file.file_type;​ 
-  cursor emp_cursor is 
-    SELECT * FROM employees 
-   ORDER BY employees.salary DESC;  ​ 
-    
-   emp emp_cursor%rowtype;​ 
-   BEGIN 
-    
-   ​v_filehandle := utl_file.fopen('​data_dir',​ '​out.txt',​ '​w'​);​ 
-    
-   -- open emp_cursor; 
-   for emp in emp_cursor  ​ 
-     loop 
-      dbms_output.put_line(emp.salary);​ 
-      utl_file.putf(v_filehandle,​ emp.salary);​ 
-      utl_file.new_line(v_filehandle);​ 
-      ​ 
-  end loop; 
-     ​utl_file.fclose(v_filehandle);​ 
-END; -- Procedure 
-</​code>​ 
kurs/write_to_file_utl_file.txt ยท Last modified: 2014/09/10 21:22 (external edit)