Bulk copy to text file in Oracle

[manoop]

Hi friends

How to bulk copy the output of a query to textfile in PL/SQL


Thanks

Manoop

[amitpatel66]

Hi friends

How to bulk copy the output of a query to textfile in PL/SQL


Thanks

Manoop

You can make use of UTL_FILE package for writing data to text file using PLSQL.

[manoop]

You can make use of UTL_FILE package for writing data to text file using PLSQL.

We want the output in a comma seperated format.

[debasisdas]

We want the output in a comma seperated format.

then try to use the SPOOL command.

[amitpatel66]

You can make use of UTL_FILE package for writing data to text file using PLSQL.

You can also try this:

Have a cursor that selects the data from the table in the format:
CURSOR C1 IS SELECT empno||','||ena me from emp;
LOOP through the cursor and write the data using UTL_FILE record by record.

or

Use SPOOL command as suggested in above post