Oracle Export to csv nightly / daily
Posted on 2014-10-14
We are currently using oracle 9i for our ERP system.
Is there a way I can run a script daily which would export the select query to an csv file.
pc.total_accum_cost as Invent_Value,
ip.part_product_code as category
from ifsapp.inventory_part ip, ifsapp.company co, ifsapp.part_cost pc, ifsapp.inventory_part_in_stock ipos
where co.company = ip.contract and
ip.part_no = pc.part_no and
pc.cost_set = '1' and
ip.Part_status != 'O' and
ipos.part_no = ip.part_no and
ip.part_product_code < '500' and
ipos.location_type = 'Picking'
order by ip.part_no
This basically dumps all our inventory parts out of our system c/w description, dim, prices and stock values.
Massive thanks in advance.