Đ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

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 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, export csv file oracle table, 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

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

Mã Dự Án: #1863051

Đã trao cho:

aghosh07

Hi, Please check PMB. Thanks.

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