oracle修改表字段的次序

SQL codeSQL>CREATETABLE T_TABLE(NAMEVARCHAR2(11),SEXCHAR(1),AGENUMBER(3));

Table created
 
SQL>DESC T_TABLE
Name Type         NullableDefault Comments

---- ------------ -------- ------- --------

NAMEVARCHAR2(11) Y                        
SEXCHAR(1)      Y                        
AGENUMBER(3)    Y                        
 
SQL>
SQL>UPDATE SYS.COL$

SET    COL#= DECODE(COL#,2,3,2)

WHERE  obj#= (SELECTOBJECT_ID

FROM   ALL_Objects

WHEREobject_name='T_TABLE'

AND    OWNER='SYS'

AND    SUBOBJECT_NAMEISNULL)

AND  COL#>1;

2 rows updated
SQL>COMMIT;Commit complete

SQL>ALTER SYSTEM FLUSH SHARED_POOL;
 
System altered
 
SQL>DESC T_TABLE;
Name Type         NullableDefault Comments

---- ------------ -------- ------- --------

NAMEVARCHAR2(11) Y                        
AGENUMBER(3)    Y                        
SEXCHAR(1)      Y                        
 
SQL>select column_name,column_idfrom user_tab_colswhere table_name='T_TABLE';
 
COLUMN_NAME                     COLUMN_ID

------------------------------ ----------

NAME1
SEX3
AGE2