script to populate table

[pando]

Hi

Has anyone got a script to generate data from a table with data

for example

column1-----column2-----column3
abc----------xyz-----------efg

the script should generate a flat file

abc, xyz, efg

By the way should work with any table not just the one above (one table is easy with dynamic SQL)
Would be somthing like passing the table name as parameter then the script would generate all the data

cheers

[marist89]

See [url]http://govt.oracle.com/~tkyte/flat/index.html[/url]

I modified these methods to work very effectively with data in my database.

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5636[/url]

[pando]

btw I forgot to reply this one, mariest I need not only data but also the

insert blah blah values blah blah

The script in ask tom only extracts data