I have written a Unix Shell script where, the data gets loaded into the Oracle table from an Input.csv file, and an e-mail notification will be sent if the data load is a success or a failure to the users.
I am in need of modifying the script. I need the following to be modified in my script.
1) The script should count the number of line in the Input.csv file and send an email to the users.
2) The script should notify the users the the Input.csv file contains duplicate records in it (if any duplicate records exists).
3) If no duplicate records exists in the input.csv file and the data gets loaded into the Oracle table, the script should calculate the total no. of records loaded into the table, and e-mail the users.
I need this script in Unix. Can anyone please help me out with this..





