select 'alter table '||s.table_name||' add constraint '||s.constraint_name||
       ' check ('||s.search_condition||');'
  from (select table_name, constraint_name, constraint_type, search_condition
          from DBA_CONSTRAINTS 
          where owner='PARUS'
                and constraint_type='C') s

declare
    v_search_condition varchar2(32767);
begin
    for c in (select c.search_condition
                from all_constraints c
               where rownum = 1) loop
        v_search_condition := c.search_condition;
        dbms_output.put_line(v_search_condition);
    end loop;
end;