File Handling using UTL in Oracle PLSQL
- How to check file avilabilty in the directory
UTL_FILE.fgetattr(v_dir_path, v_file_name, v_exists, v_f_len, v_bsize);
- remove the existing file from the directory
UTL_FILE.fremove (v_location, v_file_name )
1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...