ORACLE INVISIBLE Column can be used for column ordering

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
  • EMAIL

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
  • EMAIL
  • CREATED_BY

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *