- 根据oracle用户和表名,查询表的ID号
SELECT object_id FROM all_objects WHERE owner = 'MYCIMLED_PRO' AND object_name = 'UPLOAD_DATA_PROBER';
- 根据id去查询该表中的字段以及字段序号,FOR UPDATE 调整COL#字段的序号
SELECT obj #, col #, name FROM sys.col$ WHERE obj #= 149373 ORDER BY COL # FOR UPDATE;