I have one flat file coming to server in a particular directory. I need to write a UNIX shell script to uplaod data from this file to Oracle database. What I am planning to do is , at a specified time this unix script will run and will search for 'flatdatafile.txt' in the ' /flatdatafiles/' directory. When this script runs, automatically data from this file will get populated to the database in table 'invoice_data_tbl' .
Please help...I am new to UNIX shell programming.