从Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production中断开
SQL>
SQL> desc b;
名称
是否为空? 类型
----------------------------------------- -------- ---------
A
CHAR(10)
B
CHAR(10)
SQL> alter table a rename column a to c;
alter table a rename column a to c
SQL> connect / as sysdba
已连接。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
SQL> desc hr.a;
名称
是否为空? 类型
----------------------------------------- -------- -------------------------
A
VARCHAR2(20)
B
VARCHAR2(10)