关于oracle调整列顺序的记录

来源:互联网 发布:手机淘宝黑名单在哪 编辑:程序博客网 时间:2024/05/16 16:16

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME='VEHICLE_BAK';
SELECT OBJ#,COL#,NAME FROM SYS.COL$ WHERE OBJ# =52050 order by COL#;

update SYS.COL$ set COL#=68 where OBJ# =52050 and name='REMARK';
     commit;

记得要重启