select name , length(lob1) lob1Len , substr(lob1, 1, 30) left , substr(lob1, max(length(lob1)-29, 1), 30) right , substr(lob1, max(length(lob1) / 2, 1), 30) middle from QZ92CRT.TQZ91QBLOGORI ;