Oracle 新增字段后调整字段顺序

 

1. 根据oracle用户和表名，查询表的ID号

   SELECT
       object_id 
   FROM
       all_objects 
   WHERE
       owner = 'MYCIMLED_PRO' 
       AND object_name = 'UPLOAD_DATA_PROBER';

    

2. 根据id去查询该表中的字段以及字段序号，FOR UPDATE 调整COL#字段的序号

   SELECT
       obj #,
       col #,
       name 
   FROM
       sys.col$ 
   WHERE
       obj #= 149373 
   ORDER BY
       COL # FOR UPDATE;