Hot answers tagged

2

That limitation is for a single line. You can break your statement into multiple lines to overcome that limitation, such as: begin :sql_txt := 'select ... ' || ' ... ' || ... ' ... '; end; /


1

The length of a CLOB output is limited. You can increase the limit with set long n, example: set long 50000


Only top voted, non community-wiki answers of a minimum length are eligible