export data as fixed length ASCII text file

[Allan12345]

Hi,

Can someone tell me how to export query data or the data in a table as a fixed length text file. I use PL/SQL Developer to query the data.

Many thanks,

 

[Kirurgs]

What do you mean by "fixed length" text file?
You can use "export data" feature, right-click on table -> export data...

 

[Allan12345]

That would be a binary file if I use "export data" feature, right-click on table -> export data

 

[Kirurgs]

In the basics all files are binary
But what you can get with export data are insert statements for your data...
You can also query data in sql window and right-click on query result grid -> export results (csv file, xml file, ...), that would be your "true" text file...

 

[Marco van der Linden]

@Allan12345: Do you mean to export data(grid) with fixed width columns rather than delimited? If so I agree that it would be nice to have that as a 'standard' functionality rather then to have to write your own query left and right padding.
Hmm, I envision a popup window listing all the table/query columns with padding checkbox (left/right) and number of positions to pad. Maybe someone could write this as a plug-in

 

[Marco Kalter]

Someone could indeed write a Plug-In. We have an RTF export Plug-In available as example.

 

[Allan12345]

Yes, I mean to export data(grid) with fixed width columns rather than delimited.

Thanks,

 

[Troy Allen Cross]

Has anyone figured out an easy way to generate a fixed width columns file from a SQL query within PL/SQL Developer?

Troy

 

[amaury]

What about the Command Window?
the display is in fixed-width format, and you can spool the results in a file.

Amaury