Hi ,
I am looking for shell script command which can help me to give output like Processed Records, Skipped Records, Warnings Records, Deleted Records which we will store in Shell script variables and then will use these variables to manage loading history for each file.
I know basic command which works via command line is - ( this is windows and I plan to implement similar in Unix box with error logging using shell script)
sqlldr LOCAL/LOCAL control=UTL_FILE\Import\trans.ctl data=UTL_FILE\Import\trans_20200423_0300.csv log=UTL_FILE\Import\trans_20200423_0300.log bad=UTL_FILE\Import\trans_20200423_0300.bad
Is it feasible to capture these details if so - any directions or shell scripts directions ?
Thanks