I need to export 60 tables to CSV file. 1 csv file per table.
I need help and need instructions on how to do this.
I am no export in oracle but here is what i researched.
Here is sample code that i researched using PL/SQL
create or replace procedure test_dump_csv
l_rows := dump_csv( 'select *
',', '/tmp', '[url removed, login to view]' )
dump_csv( 'select f1, f2 from t1',',', '/tmp', '[url removed, login to view]' )