SELECT T.OBJ#, T.COL#, T.NAME, T.ROWID
FROM SYS.COL$ T
JOIN ALL_OBJECTS A
ON A.OBJECT_ID = OBJ#
WHERE A.OWNER = 'NGMESUSER'
AND A.OBJECT_NAME = 'TB_FACTORY';
拿sys登录，修改col顺序。重启数据库服务，使生效：SQL>SHUTDOWN SQL>STARTUP
转载于:https://www.cnblogs.com/zhahost/archive/2013/05/21/3091042.html
