ALTER TABLE RENAME COLUMN To rename a column, we need to do it through ALTER TABLE. Let's see a table. SQL> desc employees; Name … Read More »How Oracle Rename Column
One developer reported that some statements like the following failed to complete. SQL> insert into finapp.invoices_history select * from finapp.invoices_month where invoice_date < sysdate -30;… Read More »How to Change Column Order and Position
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
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