17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> CREATE TABLE T_TABLE(NAME VARCHAR2(11),SEX CHAR(1),AGE NUMBER(3));
Table created
SQL> DESC T_TABLE
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
NAME VARCHAR2(11) Y
SEX CHAR(1) Y
AGE NUMBER(3) Y
SQL>
SQL> UPDATE SYS.COL$
2 SET COL# = DECODE(COL#, 2, 3, 2)
3 WHERE obj# = (SELECT OBJECT_ID
4 FROM ALL_Objects
5 WHERE object_name = 'T_TABLE'
6 AND OWNER = 'SYS'
7 AND SUBOBJECT_NAME IS NULL)
8 AND COL# > 1;
2 rows updated
SQL> COMMIT;
Commit complete
SQL> ALTER SYSTEM FLUSH SHARED_POOL;
System altered
SQL> DESC T_TABLE;
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
NAME VARCHAR2(11) Y
AGE NUMBER(3) Y
SEX CHAR(1) Y
SQL> select column_name,column_id from user_tab_cols where table_name='T_TABLE';
COLUMN_NAME COLUMN_ID
------------------------------ ----------
NAME 1
SEX 3
AGE 2