修改 Oracle 字段排序

--修改 Oracle 字段排序

select object_id from all_objects where owner='TIE_JXMG' and object_name='OMS_EMPLOYEE';

select obj#,col#,name from sys.col$ where obj#=78129 order by col#;

--

update sys.col$ set col#=col# + 1 where obj#=78129 and col#!=1;

update sys.col$ set col#=2 where obj#=78129 and col#=203;

 

参考：http://www.2cto.com/database/201505/399246.html