Extract data from oracle db in .txt format

Question

How to extract data from oracle db in .txt format & i need to post this files to sap server.

please guide me.

Rahul · Accepted Answer · 2017-07-23 16:16:24Z

1

You can use spool in sql/plus like below which will write to result.txt

spool result.txt    
select col1, col2, ... , coln from your_table;    
spool off

See Here for more information

answered Jul 23, 2017 at 16:16

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

1 Answer 1