Select with column long

[sslobo]

hi !!!
I need to make one select in user_cosntraints but this column search_condition is the data type Long. How ill make this

select 'alter table '||table_name||' add constraint '||
' check ('||seach_condition||');' from user_constraints
where constraint_type = 'C'

thanks !!

[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.