How to disable constraints table level on 18c database?

Answer : Using below query you can disable constraints table level on 18c database.

Query:


select 'alter table '||a.owner||'.'||a.table_name||' disable constraint '||a.constraint_name||';'
from user_constraints a, all_constraints b
where a.constraint_type = 'R'
and a.r_constraint_name = b.constraint_name
and a.r_owner  = b.owner
and b.table_name = 'TAB_NAME';