Đ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: what pl sql, sql to oracle, sql oracle pl sql, sql in pl sql, sql code oracle, procedure sql oracle, procedure pl sql oracle, procedure oracle pl sql, procedure in pl sql oracle, pl sql in oracle, pl sql code sample, pl sql and oracle, pl sql and, oracle sql pl, code pl sql, pl sql oracle, oracle sql number, in pl sql, pl\sql, pl/sql, pl-sql, oracle:pl, oracle pl/sql, oracle pl, oracle dat

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