Re: Q: how to insert text which includes a & (ampersand) using sqlplus
From: Don Chan <dchan_at_mm.is.lmsc.lockheed.com>
Date: 1996/07/10
Message-ID: <31E40E04.1421_at_mm.is.lmsc.lockheed.com>#1/1
Date: 1996/07/10
Message-ID: <31E40E04.1421_at_mm.is.lmsc.lockheed.com>#1/1
Mohan Vijay wrote:
>
> try something like...
>
> insert into tablel values(replace('A : B',':','&'));
>
> Mohan
> --------------------------------------------------------
> All opinions r just mine
> --------------------------------------------------------
If you are inserting in SQL*Plus, you can issue:
SQL> SET SCAN OFF before issuing the insert statement (or any SQL statement). With scan turned off, SQL*Plus does not prompt when it sees & inside quotes.
Regards,
Don
Contract Oracle Developer
Received on Wed Jul 10 1996 - 00:00:00 CEST