How to read a txt file then insert them into db tables
Hi,
Please help me to solve this problem. This is what I need to do:
1. read a text file which holds the values to be inserted into some database tables. For example it holds ename, deptno, sal, dname for emp and dept tables. These are in a text file now.
2. Then I need to insert these data into db tables like emp and dept, and check if there are dups or voilate any constraints. The records to be inserted are usually > 100,000, so I am also looking for a fast way to do this.
3. This operation happens regularly, so I need to schedule the job. I know this can be done by using procedures and dbms_jobs.
Any help will be greately appreciated.