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

    SQLLDR - tab delimited fields

    610916
      Hi:

      I am on 10.2.0.3 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
      replace
      into table PS_MYTABLE
      fields terminated by "," optionally enclosed by '"'