Re-Order Oracle columns of tables

Example
Create a table:

CREATE TABLE t (
    a INT,
    b INT,
    d INT,
    e INT
);
Add a column:

ALTER TABLE t ADD (c INT);
Move the column to the middle:

ALTER TABLE t MODIFY (d INVISIBLE, e INVISIBLE);
ALTER TABLE t MODIFY (d VISIBLE, e VISIBLE);
DESCRIBE t;

Name
----
A
B
C
D
E
原文地址:https://www.cnblogs.com/kakaisgood/p/12307374.html