3 Replies Latest reply: Oct 29, 2008 11:05 AM by dask99 RSS

    SQLLDR - tab delimited fields


      I am on on hp-ux B.11.23.

      Need to upload a file with tab-delimited fields. Anybody can tell me what character should be used instead of comma (when the fields are comma-separated) in this statement? TIA.

      load data infile myfile.csv
      into table PS_MYTABLE
      fields terminated by "," optionally enclosed by '"'