cassiusdrow
Member²
Code:
SELECT '999 chars makes row height one line:' x,
RPAD('-', 999, '-') x
FROM dual
UNION ALL
SELECT '1000 chars makes row height two lines:' x,
RPAD('-', 1000, '-') x
FROM dual;
If a column value has a length longer than 999 characters, the height for that row is doubled.