Loading data in an oracle table from a file using sqlldr

We will see how to load data from a file in an oracle table using sqlldr. Table We have a table EMPLOYEE in the oracle database with the following schema:- SQL> desc EMPLOYEE;  Name                                      Null?    Type  —————————————– ——– —————————-  EMP_ID                                    NOT NULL NUMBER(38)  EMP_NAME                                           VARCHAR2(500)  EMP_AGE                                            NUMBER(38) Data File We…

Continue reading