Oracle ALTER TABLE DROP Column By Examples
The syntax of dropping a column is pretty easy. SQL> show user USER is "HR" SQL> alter table employees drop column salary; Table altered. As… Read More »Oracle ALTER TABLE DROP Column By Examples
ORA-12992
How to Resolve ORA-12992: cannot drop parent key column
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 Resolve ORA-12992: cannot drop parent key column