调整Oracle数据库中表字段的顺序

调整Oracle数据库中表字段的顺序

第一步，从数据字典视图查询出表的id

select object_id from all_objects where owner='SUNYARD' and object_name='TBL_WDC_INF';

第二步，通过id查出该表中所有字段的顺序

select obj#,col#,name from sys.col$ where obj#=89677;

第三步，更新字段的顺序

update sys.col$ set col#=0 where obj#=89677 and name='SN';
update sys.col$ set col#=7 where obj#=89677 and name='ANSWERCODE';
update sys.col$ set col#=9 where obj#=89677 and name='STATUS';
update sys.col$ set col#=4 where obj#=89677 and name='TOACCNO';
update sys.col$ set col#=3 where obj#=89677 and name='ACCNO';

update sys.col$ set col#=8 where obj#=89677 and name='CHECKCODE';
update sys.col$ set col#=5 where obj#=89677 and name='AMOUNT';
update sys.col$ set col#=2 where obj#=89677 and name='MERCHANTID';

update sys.col$ set col#=1 where obj#=89677 and name='SN';

注意：上述更新需要DBA权限