摘要： select TABLE_NAME,CONSTRAINT_NAMEsfrom (select TABLE_NAME,CONSTRAINT_NAMEs, row_number() over(partition by TABLE_NAME order by TABLE_NAME,curr_level desc) CONSTRAINT_NAMEs_rankfrom (select TABLE_NAME,CONSTRAINT_NAME,rank,level as curr_level,ltrim(sys_connect_by_path(CONSTRAINT_NAME,','),' 阅读全文