Re: Dynamic SQL to disable constraints.

Look at:

DECLARE
    CURSOR crConstraints IS
    SELECT 'alter table '|| owner || '.' || constraint_name

        || ' disable constraints' sql
    FROM dba_constraints
    WHERE constraint_type = 'R'
    AND table_name = 'ORDDET';

BEGIN
    for x in crConstraints loop

        execute immediate x.sql;
    end loop;
END;
/ Received on Tue Sep 21 2004 - 08:46:17 CDT