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
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-00907: missing right parenthesis
ORA-00907 ORA-00907 means that SQL parser saw an illegal string or expression where it expects a right parenthesis to close the inner statement. Usually, it's… Read More »How to Resolve ORA-00907: missing right parenthesis
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
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 Oracle 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 Oracle 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