Home » RDBMS Server » Server Utilities » Re: How does one export an Oracle table to a Comma Delimited Flat File
Re: How does one export an Oracle table to a Comma Delimited Flat File [message #367981] Mon, 23 August 1999 20:26
KenHP
Messages: 6
Registered: August 1999
Junior Member
Colin is right, you can do it with SQLPlus, but...

you need to be aware of the data, and if there may be commas or quotes in any character columns, add enclosing quotes for the columns, and possibly REPLACE(col1,'''','''''') or whatever.

Ken
Previous Topic: Calling SQL*LOADer from a stored procedure
Next Topic: Re: How does one export an Oracle table to a Comma Delimited Flat File
Goto Forum:
  


Current Time: Mon Jan 30 17:34:42 CST 2023