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 Oracle 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