修改ORALCE表字段顺序
使用超级管理员登录
select object_id
from all_objects
where object_name = ‘表名’ ;
select obj#,col#,name
from sys.col$
where obj#=object_id;
update sys.col$ set col#=27 where obj#=119700 and name='字段名'
修改ORALCE表字段顺序
使用超级管理员登录
select object_id
from all_objects
where object_name = ‘表名’ ;
select obj#,col#,name
from sys.col$
where obj#=object_id;
update sys.col$ set col#=27 where obj#=119700 and name='字段名'