Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Control File: TAB (ascii 9)

Re: Control File: TAB (ascii 9)

From: Bill Bearden <bbearden_at_bcl.net>
Date: 15 May 98 11:55:28 GMT
Message-ID: <01bd7ff8$c9513000$a1bccecf@bbearden>


I have done it 2 ways.

  1. Type the tab char between two single quotes: ' ' I think this is hard to read since you can't really tell that it is a tab char unless you look at the control file with a binary file viewer
  2. The second is: X'09'. That is an X, a single quote, 09 and a single quote. The syntax here is very strange I think.

Bill Bearden
Consultant

Tim Romano <tim_at_superstream.net> wrote in article <355872F8.2EC8B2F9_at_superstream.net>...
> How do you specify in the control file that columns in the
> incoming text file are TAB-delimited [ascii 9]?
>
> FIELDS TERMINATED BY _____
>
> TIA
> Tim
>
Received on Fri May 15 1998 - 06:55:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US