Thanks for the question, Richard.
Asked: January 17, 2017 - 9:51 pm UTC
Last updated: January 18, 2017 - 2:20 am UTC
Version: 9i+
Viewed 1000+ times
You Asked
I am looking for a host operating system utility, which would efficiently extract data from any ORACLE table into a flat file, similar to Sybase ASE or SQL Server bcp utility. The utility should take connection parameters with user credentials along with fully qualified table or view name as command line parameters. Preferably it should allow to specify field and row termination strings (to avoid confusion with the field data), and a counter of the extracted rows at the end of the file. Does anything like this exist for Oracle?
and Connor said...
Is this answer out of date? If it is, please let us know via a Comment