Hi DBAs,
In order to take an export of some few tables of a schema I want to write a SQL query or in PL/sql which will give the result like below in one line:
table1, table2, table3, etc...
I have tried something like the following but doesn't seems to work - it returns me the last row only:
SQL>l
1 declare
2 cursor c1 is select table_name from dba_tables where owner='TROPP' ;
3 tname varchar2(30000):= null ;
4 begin
5 for i in c1
6 loop
7 tname:= i.table_name||',';
8 end loop;
9 dbms_output.put_line(tname);
10* end;
SQL>/
W_RATE,
Any idea how to achieve this?
TIA
Regards,