hi,

iam attaching the script .pls check it out.

create or replace procedure input_table(taname in varchar2)
is
str varchar2(32767);
cnt number(2);
cursor c1(tabname in varchar2)
is
select column_name
from all_tab_columns
where table_name = tabname
order by column_id;
rec c1%rowtype;
begin
str:= 'declare '||
'cursor c2 '||
'is '||
'select rownum';
open c1(taname);
loop
fetch c1 into rec;
exit when c1%notfound;

str:= str||'||'',''||'||rec.column_name;

end loop;
close c1;
str:= str||' SRC from '||taname||';'|| ' r2 c2%rowtype;'||
' begin '||' for r2 in c2'||' loop '||
' dbms_output.put_line(r2.SRC);'||
' end loop;'||
' end;';
execute immediate(str);
end;
/


here the rownumber is included.i want to remove the rownumber.
is it possible to write the file in utl_file.

Thanks,
Ratheesh