Re: Insert failure

Hi Norman

Your right, the data did truncate - I'll pay more attention to what's inserted next time!

Alistair

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702D3DDB4_at_lnewton.leeds.lfs.co.uk...
> 'set scan off' in sqlplus does the job. Not sure about SQLLoader - as I
> don't use it myself (yet).
>
> SQL> create table test (a varchar2(100));
> Table created.
>
> SQL> set scan on
> SQL> insert into test values ('Hello & goodbye');
> Enter value for goodbye:
> old 1: insert into test values ('Hello & goodbye')
> new 1: insert into test values ('Hello ')
> 1 row created.
>
> SQL> set scan off
> SQL> r
> 1* insert into test values ('Hello & goodbye')
> 1 row created.
>
> SQL> select * from test;
>
> A
> ----------------------------------------------------
> Hello
> Hello & goodbye
>
>
> So the poster who 'just pressed enter' (Alistair) may well have inserted
> truncated data into his table :o(
> as can be seen from the select above.
>
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Wed Oct 23 2002 - 08:02:12 CDT