SQL*Plus: Release 9.2.0.1.0 - Developer's Release on Sat Feb 21 22:04:00 2004

SQL> CREATE TABLE testit (id INTEGER PRIMARY KEY);

Table created.

SQL> desc testit
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 ID                            NOT NULL NUMBER(38)

SQL> ALTER TABLE testit RENAME COLUMN id TO testit_id;

Table altered.

SQL> desc testit
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 TESTIT_ID                     NOT NULL NUMBER(38)

SQL> @constr testit

Type     Constraint name           Definition                                         Status
-------- ------------------------- -------------------------------------------------- --------
Primary  SYS_C001660               Primary key (TESTIT_ID)                            ENABLED

SQL> ALTER TABLE testit RENAME CONSTRAINT SYS_C001660 TO testit_pk;

Table altered.

SQL> @constr

Type     Constraint name           Definition                                         Status
-------- ------------------------- -------------------------------------------------- --------
Primary  TESTIT_PK                 Primary key (TESTIT_ID)                            ENABLED

SQL>