Đang Thực Hiện

116884 Oracle 8i export to csv file

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

Step 1.

create or replace procedure test_dump_csv


l_rows number


l_rows := dump_csv( 'select *

from t1',

',', '/tmp', '[url removed, login to view]' )




dump_csv( 'select f1, f2 from t1',',', '/tmp', '[url removed, login to view]' )

Kỹ năng: Bất kì công việc gì, Oracle

Xem thêm: oracle export csv, sql code oracle, procedure oracle sql, procedure sql oracle, sql code sample, code sql, oracle sql number, oracle pl, oracle dat, f2, f1, export, csv file, table csv, using oracle, export sql, csv table, sql test number, sql file csv, csv file code, csv create, oracle procedure, oracle create table, select oracle, create table oracle

Về Bên Thuê:
( 44 nhận xét ) United States

Mã Dự Án: #1863051

Đã trao cho:


Hi, Please check PMB. Thanks.

$10 USD trong 0 ngày
(0 Đánh Giá)