Đang Thực Hiện

117302 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

as

l_rows number

begin

l_rows := dump_csv( 'select *

from t1',

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

end

/

Step2

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

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

Xem thêm: 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 export csv, oracle create table, select oracle, create table oracle

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

Mã Dự Án: #1863469

Đã trao cho:

redgreenbluesl

Check pmb ..i worked in oracle company..thanks

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