SQL*PLUS Long data
From: ccrissma_at_ucs.att.com <(ccrissma_at_ucs.att.com)>
Date: 1995/09/29
Message-ID: <1995Sep29.200553.29580_at_ucseng.ucs.att.com>#1/1
Date: 1995/09/29
Message-ID: <1995Sep29.200553.29580_at_ucseng.ucs.att.com>#1/1
Help please! I am attempting to insert some data into a long type field via a sql script with SQL*PLUS. My long text has some blank lines. Like this:
insert into tablename
values ('non_long_field_value',
'long data - test test text test text
test test test
test test tes
test tes test tes
tes tes test trext
blah blah blah');
It handles the first 2 lines of the long and then gives me an error at the start of line 4 (line after the 1st blank line).
What am I doing wrong? I thought EVERYTHING between the single quotes (') was treated as one chunk.
Any help would be appreciated. Thanks.
-- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% Charlie Crissman - ccrissma_at_ucs.att.com AT&T Universal Card Services - Database Administration (904) 954-8159Received on Fri Sep 29 1995 - 00:00:00 CET