Tutorial by Examples

Suppose you have a table and you want to change one of this table primary id. you can use the following scrpit. primary ID here is "PK_S" begin for i in (select a.table_name, c.column_name from user_constraints a, user_cons_columns c where a.CONSTRAINT_TYPE...

Suppose you have the table T1 and it has relation with many tables and its primary key constraint name is "pk_t1" you want to disable these foreign keys you can use: Begin For I in (select table_name, constraint_name from user_constraint t where r_constraint_name='pk_t1') loop E...