The following how could replace my commas with a designated number of spaces, it 10 spaces, or 5 spaces for simply readability of the output
utl_file.put_line(v_output_file1, cursor_emp.empno || ',' || cursor_emp.ename || ',' || cursor_emp.deptno);
Printable View
The following how could replace my commas with a designated number of spaces, it 10 spaces, or 5 spaces for simply readability of the output
utl_file.put_line(v_output_file1, cursor_emp.empno || ',' || cursor_emp.ename || ',' || cursor_emp.deptno);
You mean like ...
Code:utl_file.put_line(v_output_file1, RPad(cursor_emp.empno,10) || RPad(cursor_emp.ename,30) || RPad(cursor_emp.deptno,10));
yeah that would it thanks, i was thinking of something like an ASCII equiviant but the rpad would work just as well , tks dave