Forcing Oracle to break up a line into 2 new lines
M1k3GNov 10 2010 — edited Nov 16 2010Hi. I am creating an interface file that needs specific length for each line. If my code returns a text line of 180 characters for instance,, I need to force it to return 3 lines instead of 60 characters each. I am working in PLSQL, so no references to SQL plus please. Is there some way of wrapping text in Oracle? I found a reference to chr(10) when googling, but this generated an empty space, and no new lines. Any ideas?