ALL_CONS_COLUMNS

How to Resolve ORA-12992: cannot drop parent key column

by Ed Chen
June 23, 2023July 2, 2023

ORA-12992 Tried to drop a column from a table, but it failed with ORA-12992. SQL> alter table customers drop column customer_id; alter table customers drop… Read More »

How to Find References to Table

by Ed Chen
April 26, 2023April 28, 2023

Referential Integrity To check the referential relationship of a table in details, we have to join some dictionary views, ALL_CONSTRAINTS and ALL_CONS_COLUMNS. For example, we'd… Read More »

How to Resolve ORA-12991 Error Message

by Ed Chen
April 25, 2020July 2, 2023

ORA-12991: column is referenced in a multi-column constraint ORA-12991 means that the column you want to drop is bound to some multi-column constraints. You must… Read More »

How to Check Primary Key in Oracle

by Ed Chen
April 15, 2020December 10, 2022

For getting the information of a primary key, we have to join two dictionary views, one is ALL_CONS_COLUMNS, the other is ALL_CONSTRAINTS. And then we… Read More »

How Oracle Add NOT NULL Constraint

by Ed Chen
November 23, 2019December 10, 2022

Add NOT NULL Constraint As I mentioned in resolving ORA-00904 for adding a constraint, NOT NULL is a constraint, but it's more like an attribute… Read More »

JavaScript is not enabled. Please enable it and reload the page.