1 Reply Latest reply on May 8, 2013 4:08 AM by orcldeveloper-Oracle

    sql loader want to skip unwanted charcters from a flat file while loading

      Hi all,

      i have some character "/" is placed in flatfile while unloading data to a flat file from database. how to skip that "/" while loading it back.

      for a column if i have the data in table as " Iam a DBA" . in flat file it has like " iam / a / dba". for space it is unloading as '/'.
      when i want to reaload data from flat file "iam / a / dba" to database as " Iam a DBA" is there a way i can Skip "/" while loading data