String PL/SQL Function
546215Nov 21 2006 — edited Nov 21 2006hi,
I require a PL/SQL Function which would split a line in to two if the length of the line is greater than 80.
for ex i/p: LEASE OF ONE CANON FAX MACHINE LASER CLASS 9000L MODEL. TO REPLACE CANNON MODEL CFX-L4000 (DB270). LEASE FOR 36 MOS @ $45.61/MO. IF NOT CORRECT LEASE TIME PLEASE INFORM-NANCY SZATKOWSKI 518-385-7614. MACHINE LOCATED IN BLDG 273 ROOM 2270 BY TONY KACZKOWSKI.
which is of length 257 characters,function should split this one line with length 257 characters in to three lines with 80 characters and one line with remaining 17 characters.
if the i/p line length is less than 80 it should return the same line if the line length is greater than 80 it should split it in to two or more lines ensuring that splitted lines length is less than 80.
Thanks & Regards