I need an Oracle procedure that needs to do the following work:
1. Check to see if the external table exists, if it does delete it.
2. Create the external table.
3. Move the data from the external table into another table.
4. Check the final table for duplicate records.
I will provide 95% of the code. It is just buggy and does not work completely. I need this ASAP. It is probably an hours work if youhave extensive experinec with DDL statements within Oracle Procedures.