How Oracle Rename Column
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
Column
Oracle ALTER TABLE ADD Column By Examples
ALTER TABLE ADD COLUMN In this post, I'll show you some practical examples of adding a column to table from the simplest to the complicated.… Read More »Oracle ALTER TABLE ADD Column By Examples
Alter Table Move LOB to Another Tablespace
Move LOB Segment Whenever tablespace is crowded, the first thought in my mind is to move INDEX to another tablespace, because it's very flexible to… Read More »Alter Table Move LOB to Another Tablespace
How to Resolve ORA-01439: column to be modified must be empty to change datatype
ORA-01439 ORA-01439 means that the data type of a column you want to change is not empty, you have to make it empty first, then… Read More »How to Resolve ORA-01439: column to be modified must be empty to change datatype
How to Change Column Order and Position
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
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-00932: inconsistent datatypes: expected CHAR got LONG
ORA-00932 ORA-00932 means that SQL engine wanted to retrieve CHAR strings, but it saw LONG data type, which is unsearchable. So SQL engine refused to… Read More »How to Resolve ORA-00932: inconsistent datatypes: expected CHAR got LONG
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
How to Resolve ORA-01442: column to be modified to NOT NULL is already NOT NULL
ORA-01442 ORA-01442 means that the target column of table is already NOT NULL, so you don't have to add NOT NULL on the column. I… Read More »How to Resolve ORA-01442: column to be modified to NOT NULL is already NOT NULL
How Oracle Disable NOT NULL Constraint
After you add a NOT NULL constraint to a column, you might want it stop temporarily. In such moment, you should consider to disable NOT… Read More »How Oracle Disable NOT NULL Constraint