-
Specifying spaces with utl_file.put_line
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);
I'm stmontgo and I approve of this message
-
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
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|