var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Oracle to Fixed-Width Flat File
I need to create a fixed width flat file from PL/SQL.
Now I know I can use utl_file to create a CSV(Comma Separated Values) file. (Unfortunately, this requires a reboot of instance and a hard code of directory value)
But, I don't want a CSV file, I want a fixed width file.
I would like to encapsulate this in a PL/SQL procedure and not require SQL Plus.
Concatenate the result set ... spool out to a file turning off
heading, verify, trimspool... set linesize to the linesize of the output
select username||chr(9)||sid||chr(9)||serial#||chr(9)||pr ogram from v$session;
Can I run SQL*Plus script from within PL/SQL?
I have some pl/sql and as a last step I want it to create the fixed width file.
I create .BAT files that run sqlplus @filename ... The file that gets
run is sql commands that spool ...