Select with column long

[LND]

select 'alter table '||table_name||' add constraint ' a1,
constraint_name||' check (' a2,
search_condition a3,
') '||decode(status,'DISABLED','DISABLE','') a4,
'/' a5,
table_name a_table

and if sqlplus, then
set long nnnn (eg. 100000)

Otherwise use PL/SQL: in 815 you really can fecth long into varchar2.