12c: reorder the columns in a table! Wow!

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jan 13 22:02:35 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Jan 13 2014 22:01:16 -05:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> set linesize 200
SQL> set trimspool on
SQL> set numformat 99
SQL> column column_name format a1

SQL> create table brian
  2  (
  3          i number,
  4          d number,
  5          a number,
  6          l number,
  7          f number,
  8          e number,
  9          t number,
 10          r number,
 11          g number,
 12          z number
 13  );

Table created.

SQL>
SQL> insert into brian values ( 1, 55, 21, 34, 1, 8, 2, 13, 5, 3);

1 row created.

SQL>
SQL> alter table brian modify i invisible;

Table altered.

SQL> alter table brian modify i visible;

Table altered.

SQL> alter table brian modify d invisible;

Table altered.

SQL> alter table brian modify a invisible;

Table altered.

SQL> alter table brian modify l invisible;

Table altered.

SQL> alter table brian modify e invisible;

Table altered.

SQL> alter table brian modify t invisible;

Table altered.

SQL> alter table brian modify t visible;

Table altered.

SQL> alter table brian modify z invisible;

Table altered.

SQL> alter table brian modify z visible;

Table altered.

SQL> alter table brian modify g invisible;

Table altered.

SQL> alter table brian modify r invisible;

Table altered.

SQL> alter table brian modify g visible;

Table altered.

SQL> alter table brian modify e visible;

Table altered.

SQL> alter table brian modify r visible;

Table altered.

SQL> alter table brian modify a visible;

Table altered.

SQL> alter table brian modify l visible;

Table altered.

SQL> alter table brian modify d visible;

Table altered.

SQL>
SQL> select * from brian;

  F   I   T   Z   G   E   R   A   L   D
--- --- --- --- --- --- --- --- --- ---
  1   1   2   3   5   8  13  21  34  55

SQL> select column_name, column_id, hidden_column, segment_column_id, internal_column_id
  2  from user_tab_cols
  3  where table_name = 'BRIAN'
  4  order by internal_column_id
  5  ;

C COLUMN_ID HID SEGMENT_COLUMN_ID INTERNAL_COLUMN_ID
- --------- --- ----------------- ------------------
I         2 NO                  1                  1
D        10 NO                  2                  2
A         8 NO                  3                  3
L         9 NO                  4                  4
F         1 NO                  5                  5
E         6 NO                  6                  6
T         3 NO                  7                  7
R         7 NO                  8                  8
G         5 NO                  9                  9
Z         4 NO                 10                 10

10 rows selected.