title: Load float data into external table in Oracle
body: <p>I'm having a troubles with loading <code>FLOAT</code> data into the external table... Data like that: <code>+00000700000,00</code>. Any ideas how to do this? <code>FLOAT EXTERNAL</code> or <code>FLOAT(15)</code> does not work... Of course in <code>CREATE</code> statement I have <code>FLOAT</code> column.</p>
  
  <p><code>FLOAT</code> will only load first 4 characters... Leaving it as a <code>CHAR(15)</code> also does not work...</p>
  
  <pre><code>create or replace PROCEDURE LOAD_TO_EXTERNAL AS
    PATH_FILE VARCHAR2(100) := 'TEST_FILE.TXT';
    DELIMETER VARCHAR2(100) := '-';
    DATE_FORMATTING VARCHAR2(100) := 'YYYY-MM-DD';
    STMT VARCHAR2(5000);
  BEGIN
    STMT := 'CREATE TABLE "TEST_EXT"
      (
        DATA DATE,
        NAME VARCHAR2(40),
        AGGR_NUM FLOAT(27)
      )
      ORGANIZATION EXTERNAL
      (
        TYPE ORACLE_LOADER DEFAULT DIRECTORY MY_DIR ACCESS PARAMETERS
        (RECORDS DELIMITED BY ''' || DELIMETER || '''
        FIELDS LRTRIM (
            DATA CHAR(10) DATE_FORMAT DATE MASK ''' || DATE_FORMATTING || ''',
            NAME CHAR(40),
            AGGR_NUM FLOAT         )
        ) LOCATION (''' || PATH_FILE || ''')
      )
      REJECT LIMIT UNLIMITED';
  
      EXECUTE IMMEDIATE STMT;
  END LOAD_TO_EXTERNAL;
  </code></pre>