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
ALTER TABLE DROP COLUMN
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
How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
ORA-01440 ORA-01440 means that you can't decrease the number precision of the column values directly by modifying the definition of the column. Let's see a… Read More »How to Resolve ORA-01440: column to be modified must be empty to decrease precision or scale
How to Modify VARCHAR2 to CLOB of a Column
Data Type Conversion There're several major data types built in Oracle. Character Numeric Datetime LONG RAW LOB (Large Object) In each major data types, minor… Read More »How to Modify VARCHAR2 to CLOB of a Column
How to Resolve ORA-12991 Error Message
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 Resolve ORA-12991 Error Message