Fwd: Re: specifying tab as separator in sqlLoader

From: Oliver Artelt <oli_at_md.transnet.de>
Date: Wed, 3 Jan 2001 20:59:10 +0100
Message-Id: <10730.125617@fatcity.com>

hi,

try TERMINATED BY X'hexstring'
(is tab 0x09?)

oli

On Wednesday 03 January 2001 01:09, krishna_at_nehanet.com wrote:
> Hi,
>
> In Oracle8i (8.1.6) how do you specify "tab character" alone as the
> separator? Using "TERMINATED BY WHITESPACE" includes whitespaces also...
>
> Thanks,
> -Krishna.

--
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------

-------------------------------------------------------

-- 
---

Oliver Artelt, System- und Datenbankadministration
---------------------------------------------------------------
  cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
   email: oli@cubeoffice.de # web: http://www.cubeoffice.de
---------------------------------------------------------------

Received on Wed Jan 03 2001 - 13:59:10 CST