Re: special characters
From: Mark Malakanov <markmal_at_home.com>
Date: Wed, 11 Apr 2001 05:12:55 GMT
Message-ID: <rJRA6.77948$XV.20031015_at_news3.rdc1.on.home.com>
Date: Wed, 11 Apr 2001 05:12:55 GMT
Message-ID: <rJRA6.77948$XV.20031015_at_news3.rdc1.on.home.com>
Loader understands hexadecimal literals. To find out rows use WHEN (n[:m]) = X'hex-str'
-- ----------------------------------------------------- Thanks, Mark "Bigfoot" <ext6axp_at_ups.com> ???????/???????? ? ???????? ?????????: news:9avrm4$o4v6_at_biko.telecom.ups.com...Received on Wed Apr 11 2001 - 07:12:55 CEST
> Hi everyone,
>
> I have loaded hundreds of records into my table using SQL*LOADER.
> I came to know that there could be some special characters in the
> flat file because the file is ftp-ed from Mainframe.
> Is there a way to find out those rows or data that have special
> characters on it.
>
> Thanks
> Pushparaj
>
>