How to reorder ORACLE table columns?
Sample table
CREATE TABLE test_column ( id NUMBER, name VARCHAR2 (200), created_by VARCHAR2 (50) );
Add a column
ALTER TABLE TEST_COLUMN ADD EMAIL VARCHAR2(50);
Column Order will be
- ID
- NAME
- CREATED_BY
Reorder Email next to NAME.
ALTER TABLE TEST_COLUMN MODIFY CREATED_BY INVISIBLE;
ALTER TABLE TEST_COLUMN MODIFY CREATED_BY VISIBLE;
After doing so we get the table columns reordered
Column Order will be
- ID
- NAME
- CREATED_BY