宇宙的黑洞

第一法】 select * from table where name='D' UNION ALL select * from table where name<>'D' 第二法】 SELECT CASE WHEN [name]='D' THEN 0 ELSE 1 END FLAG,* FROM TABLE order by flag asc ...

1，查询表的ID select object_id from all_objects where object_name = 'CFORM_COULUMN'; 2，使用SYS账号切换到SYS数据库 3，查看表的字段详细情况 SELECT * FROM COL$ WHERE OBJ#='112043' ORDER BY COL#; 4，更新字段的顺序 UPDATE COL$ SET COL#...