Code:
 CREATE TABLE oldemp ( fname char(25), lname char(25) )
    ORGANIZATION EXTERNAL
    (TYPE ORACLE_LOADER
     DEFAULT DIRECTORY emp_dir
     ACCESS PARAMETERS
     (RECORDS DELIMINATED BT NEWLINE
      NOBADFILE
      NOLOGFILE
      FIELDS TERMINATED BY ',' (fname POSITION (1:20) CHAR, lname POSITION (22:41) CHAR)
     )
     LOCATION ('emp.dat') )
     PARALLEL 5
     REJECT LIMIT 200;
1. Can you please explain this part:

Code:
ACCESS PARAMETERS
     (RECORDS DELIMINATED BT NEWLINE
      NOBADFILE
      NOLOGFILE
      FIELDS TERMINATED BY ',' (fname POSITION (1:20) CHAR, lname POSITION (22:41) CHAR)
     )
2. Can you please explain what PARALLEL 5 is? and Why do we need it?

I will google anyway. Your help would not harm anyway