Đ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


l_rows number


l_rows := dump_csv( 'select *

from t1',

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




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 nhiều hơn: 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

ID dự án: #1863469

Được trao cho:


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

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