How can I write to a text file using Oracle?

Question

I have a select query in Oracle. I want to write query results in a txt file with CRLF (end of line) char. How can I do this?

FerranB · Accepted Answer · 2011-06-16 06:53:38Z

2

You have multiple solutions:

Use Oracle utl_file package
Throught sqlplus with spool and attribute

answered Jun 16, 2011 at 6:53

FerranB

37k18 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Botond Béres · Accepted Answer · 2011-06-16 09:05:23Z

0

You can use the utl_file package. Code fragment:

l_output        utl_file.file_type;
l_output := utl_file.fopen( p_dir, p_filename, 'w' );
utl_file.put(l_output, 'Hello' );
...
utl_file.new_line( l_output );
utl_file.fflush( l_output );
utl_file.fclose( l_output );

First of all create a directory object (the p_dir parameter of the fopen) and grant it read and write privileges. See also at http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/u_file.htm

edited Jun 16, 2011 at 9:05

Botond Béres

16.8k2 gold badges39 silver badges51 bronze badges

answered Jun 16, 2011 at 7:03

Leonardo Stallone

16

Collectives™ on Stack Overflow

How can I write to a text file using Oracle?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related