Re: HOW do I load data with semicolons

From: John Russell <jbr_at_johnruss.com>
Date: Thu, 03 Feb 2000 00:02:11 -0800
Message-ID: <38993603.564A8D3F@johnruss.com>

replace ;\n' with ;'||chr(10) with a stream editor?

John Russell
jbr_at_johnruss.com

Robert walkup wrote:
>
> Hi..
>
> I need to load data with a semicolon at the end of a line. I am using
> the Oraperl/DBI interface. With SQLPLUS I can set SQLTERMINATOR off
> and perform the insert. However I am unable to do this using the
> Oraperl interface?
>
> Example
>
> insert into t1(c1) values ('XXXXXX;
> ')
> /
>
> Anyone have any ideas on how to get around this with out removing the
> semicolon.
>
> Thanks&Best regards,
> Robert Walkup
> rdww_at_ti.com

--

---

John Russell

Only Web Data, Inc.                Phone:     415 591 0200
4 Embarcadero Center, Suite 3700   Fax:       415 591 0300

San Francisco CA 94111-4107, USA Email: jbr_at_johnruss.com

---

Received on Thu Feb 03 2000 - 02:02:11 CST