Need ideas on outputting table data to a CSV using PL/SQL in a dynamic fashion

The task is to take a list of tables which is changeable.

Write a piece of PL/SQL that when executed outputs every tables rows into individual csv files.

So if 5 tables. You will get 5 CSV files with the relevant table data in it.

The CSV should be | delimited and have " around each value (for easy import to excel)

All I know is the list of tables.

So load the list into an array at the top of the procedure, loop through this list and use UTL_FILE to output each row on a line by line basis.

I'm stuffed wondering if I need a cursor per table or if the cursor can be used dynamically to store the results from each table.

p.s. each file must also contain the column headings as the first row.

Is it even possible ? There is a list of over 30 tables, some of the tables have over 200 columns.

So ideas please :).

I'm slowly thinking this isn't possible. as i need some dynamic SQL that can gather all the column names etc. I'm getting bogged down!

It can't be a SQL script and simply spooling the output. All we ever want to do is add or remove tables from the array declaration.

Answers


Yes, it is possible. Look at this Ask Tom question that shows how to do it for 1 table at a time. All you need to do is loop through your array of table names and call Tom's procedure for each.


Need Your Help

Saving charts with dynamic view

c# winforms charts

In my WinForms application, I have to display line graphs.

Improve cufon font performance on iPhone?

iphone performance cufon

I'm using the Cufon font replacement tool on iPhone. Unfortunately, it's really slow there. (On a small 50 word page it takes about 2 seconds on my first-gen iPhone.)

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.