kurs:write_to_file_utl_file
Differences
This shows you the differences between two versions of the page.
|
kurs:write_to_file_utl_file [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:write_to_file_utl_file [2014/09/10 21:22] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <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('c:\temp', '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)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
