declare
fp utl_file.file_type;
cursor c is select * from emp;
i emp%rowtype;
begin
fp:=utl_file.fopen('DD','srk.csv','w');
for i in c
loop
utl_file.putf(fp,'\n'||' '||i.empno||' '||i.ename||' '||i.job||' '||i.sal||' '||i.hiredate);
utl_file.new_line(fp,1);
end loop;
utl_file.fclose(fp);
end;