multiline updates [message #36658] |
Mon, 10 December 2001 09:41 |
lance choad
Messages: 1 Registered: December 2001
|
Junior Member |
|
|
hello,
i am writing a perl script that genrates an update statement and call sqlplus and updates. i am having a problem. wehn i try to update something that has more than one line sql plus hangs up. for example:
update emp
set description = 'Lance Choad
is a very
good worker'
where name='Choad';
this will send to sqlplus:
update emp
set description = 'Lance Choad
is there any way to make it so it'll read and update the entire block of text includign the newlines?
Thanks a lot,
Lance Choad
----------------------------------------------------------------------
|
|
|
Re: multiline updates [message #36687 is a reply to message #36658] |
Wed, 12 December 2001 12:38 |
vk
Messages: 13 Registered: December 2001
|
Junior Member |
|
|
Try this one:
update emp
set description = 'Lance Choad'||chr(10)||
'is a very '||chr(10)||
'good worker'
where name='Choad';
----------------------------------------------------------------------
|
|
|