ok so at work I am dealing with new things learning to script, html/javascript language, Oracle/SQL commands/table/schemas and putting it all together. here is the basic break down:
Tables containing Report data (Filename, creation date/time, reporting period, an ID and which of 2 places this report pertains to.
example data:
ID = 1, RPT_NAME = D02.prt1, RPT_NUM = REPD01R02, Time = 23:49, PROC_DATE = 8/19/2013, PLANT = A.
ID = 2, RPT_NAME = D02.prt2, RPT_NUM = REPD01R03, Time = 23:49, PROC_DATE = 8/19/2013, PLANT = B.
ok now the fun part:
I need a script that will look at this data (which is in an Oracle table on one server) and pull the ID and create a folder named that ID then move the file name(RPT_NAM) from one location to that folder.
thanks in advance for any help that can be provided.