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 #367982] Mon, 23 August 1999 20:28
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

Report message to a moderator

Previous Topic: Re: How does one export an Oracle table to a Comma Delimited Flat File
Next Topic: PO8 - SVRMGR : connecting so I can create a new DB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 30 18:51:59 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.