Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9i external tables
Chuck wrote:
> Having a bit of trouble specifying a hex field delimiter character on a
> 9.2.0.5 database for an external table. Here's the DDL for the external
> table. I want to specify the TAB character as the delimiter. I know that
> "\t" will work but that's not what I'm trying to accomplish. I want to
> get the syntax right for hex delimiters. I've tried '09', 'X09', '0X09',
> '0x09', 'x09' and the same with double quotes instead of single quotes.
> The DDL executes but a query against the table returns no rows. If I
> change it to '\t' it works fine. What am I doing wrong? The 9i
> documentation says "09" or '09' but that does not work. The 10g docs say
> to put X or 0X in front of it but that doesn't work either.
>
FIELDS TERMINATED BY 0x'09'
-- Mladen Gogala http://www.mgogala.comReceived on Tue May 23 2006 - 15:40:47 CDT