Home » SQL & PL/SQL » SQL & PL/SQL » multiline updates
multiline updates [message #36658] Mon, 10 December 2001 09:41 Go to next message
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 Go to previous message
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';

----------------------------------------------------------------------
Previous Topic: Remove duplicate and leave max
Next Topic: Execute script file with variables
Goto Forum:
  


Current Time: Mon Oct 26 02:55:37 CDT 2020