title: Oracle External Table - No Rows Selected
body: <p>I've created an external table using the following definition</p>
  
  <pre><code>    CREATE TABLE EXT_TABLE (CID NUMBER, CNAME VARCHAR2(20), FEES NUMBER)
  ORGANIZATION EXTERNAL
  (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY TEST_DIR
  ACCESS PARAMETERS
      (RECORDS DELIMITED BY NEWLINE
       FIELDS TERMINATED BY ','
       (
       CID INTEGER,
       CNAME CHAR(20),
       FEES INTEGER
       )
       )
       LOCATION ('DATA.TXT'))
       REJECT LIMIT UNLIMITED;
  </code></pre>
  
  <p>table has been created. But, when i try to select data from table, I don't find any records</p>
  
  <pre><code>  SQL&gt; select * from ext_table;
  
  no rows selected
  </code></pre>
  
  <p>I've made sure directory and table have sufficient privileges for the user.
  The data in text file;</p>
  
  <pre><code>1,JAVA,300
  2,LINUX,400
  3,ORACLE,400
  4,EXCEL,500
  </code></pre>