[oracle] Get table name by constraint name

SELECT constraint_name, constraint_type, column_name
from user_constraints natural join user_cons_columns
where table_name = "my_table_name";

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to constraints

• How to trap on UIViewAlertForUnsatisfiableConstraints? • trying to animate a constraint in swift • Remove all constraints affecting a UIView • "Insert if not exists" statement in SQLite • Unique Key constraints for multiple columns in Entity Framework • SQL Server 2008- Get table constraints • How to remove constraints from my MySQL table? • Creating layout constraints programmatically • Display names of all constraints for a table in Oracle SQL • Add primary key to existing table