Ravanabrahma
Celebrity Bewarse Username: Ravanabrahma
Post Number: 23095 Registered: 06-2004 Posted From: 99.67.74.174
Rating: N/A Votes: 0 | Posted on Thursday, April 11, 2013 - 5:31 pm: | |
similar to this rayochemo chodu. declare cursor c1 is select table_name from demo_tbl_list where table_name in ( select a.table_name from dba_tab_cols a, demo_tbl_list b where a.table_name = b.table_name); cursor table_data(table_name varchar2) is select * from table_name; file_location varchar2(100) := '\tmp'; file_name varchar2(40); begin for r1 in c1 loop for r_date in table_data(r1.table_name) loop l_data := r_data.column || r_data.column...; UTL_FILE.PUT_LINE(l_file_type, p_msg); end loop; end loop; end; |