Home » SQL & PL/SQL » SQL & PL/SQL » OPtions
OPtions [message #282028] Tue, 20 November 2007 08:06 Go to next message
Messages: 754
Registered: October 2007
Senior Member
With UTL_FILE i can generate a text file with any format
for ex.
a text file with data format as :
But i have to concatenate colon after evry column.
This is tedious.
Is there any option oracle could automatically put any delimiter after evry column?
Re: OPtions [message #282029 is a reply to message #282028] Tue, 20 November 2007 08:08 Go to previous message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

In SQL*Plus (nothing related to utl_file) you use COLSEP parameter.

Previous Topic: how to written some default value from sql query
Next Topic: union all in pro *C
Goto Forum:

Current Time: Thu Jul 20 22:05:14 CDT 2017

Total time taken to generate the page: 0.13931 seconds