-
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
-
See [url]http://govt.oracle.com/~tkyte/flat/index.html[/url]
I modified these methods to work very effectively with data in my database.
Jeff Hunter
-
[url]http://www.dbasupport.com/forums/showthread.php?threadid=5636[/url]
Reddy,Sam
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|