Adjust the order of table fields in Oracle databases

Step 1: query the idselectobject_idfromall_objectswhereowner of the table from the data dictionary view.

Step 1: query the table id from the data dictionary view select object_id from all_objects where owner =

Step 1: query the table id from the data dictionary View

Select object_id from all_objects where owner = 'sunard' and object_name = 'tbl _ WDC_INF ';

Step 2: Identify the order of all fields in the table by id

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

Step 3: update the field order

Update sys. col $ set col # = 0 where obj # = 89677 and;
Update sys. col $ set col # = 7 where obj # = 89677 and;
Update sys. col $ set col # = 9 where obj # = 89677 and;
Update sys. col $ set col # = 4 where obj # = 89677 and;
Update sys. col $ set col # = 3 where obj # = 89677 and;

Update sys. col $ set col # = 8 where obj # = 89677 and;
Update sys. col $ set col # = 5 where obj # = 89677 and;
Update sys. col $ set col # = 2 where obj # = 89677 and;

Update sys. col $ set col # = 1 where obj # = 89677 and;

Note: The preceding update requires DBA permission.