PL/SQL Get Table Name by Constraint Name

select *
from user_constraints
where constraint_name like '%FK%KURUM%'
order by table_name;

******
SELECT owner, table_name
  FROM dba_constraints
 WHERE constraint_name = '%CONSTRAINT_NAME%';

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document