SQL> drop table ext_emp;

Table dropped.

SQL>
SQL> CREATE TABLE ext_emp
  2  (
  3    "NAME" VARCHAR2(80),
  4    "AGE" NUMBER(3),
  5    "GENDER" VARCHAR2(10),
  6    "X" VARCHAR2(100)
  7  )
  8  ORGANIZATION external
  9  (
 10    TYPE oracle_loader
 11    DEFAULT DIRECTORY TEMP
 12    ACCESS PARAMETERS
 13    (
 14      RECORDS DELIMITED BY NEWLINE CHARACTERSET WE8MSWIN1252
 15      BADFILE 'TEMP':'e.bad'
 16      LOGFILE 'TEMP':'e.log'
 17      READSIZE 1048576
 18      FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"' LDRTRIM
 19      MISSING FIELD VALUES ARE NULL
 20      REJECT ROWS WITH ALL NULL FIELDS
 21      (
 22        "NAME" CHAR(80) TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
 23        "AGE" CHAR(255) TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
 24        "GENDER" CHAR(10) TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"',
 25        "X" CHAR(100) TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
 26      )
 27    )
 28    location
 29    (
 30      'e.dat'
 31    )
 32  )REJECT LIMIT UNLIMITED
 33  /

Table created.

SQL>
SQL> INSERT INTO EMPLOYEETEMP
  2  (
  3    NAME,
  4    AGE,
  5    GENDER
  6  )
  7  SELECT
  8    "NAME",
  9    "AGE",
 10    "GENDER"
 11  FROM ext_emp
 12  where X is null
 13  and gender is not null;

1 row created.

SQL>
SQL>
SQL> select * from  EMPLOYEETEMP;

NAME                                                                                    AGE GENDER
-------------------------------------------------------------------------------- ---------- ----------
John Williams                                                                            23 Male

SQL>