Rename column name and table name

xiaoxiao2021-04-08  6

SQL> CREATE TABLE TEST AS SELECT * from a T_User; SQL> DESC TEST name is empty? Type ----------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------ Userid NOT NULL NUMBER (38) Loginid Not Null Varchar2 (20) Name Varchar2 (20) Password Varchar2 (20) STATUS Char (1) ExpiredDate Date Memo VARCHAR2 (50) Exchangeid Not Null Number (5) PASNUMBER VARCHAR2 (20)

SQL> ALTER TABLE TEST RENAME COLUMN NAME to Name1; SQL> DESC TEST; is the name is empty? Type -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------- ------------------ Userid NOT NULL NUMBER (38) Loginid Not Null Varchar2 (20) Name1 Varchar2 (20) Password Varchar2 (20) Status Char (1) ExpiredDate Date Memo varchar2 (50) Exchangeid Not Null Number (5) PASNUMBER VARCHAR2 (20) SQL> Rename Test to Test1; SQL> DESC TEST; error: ORA-04043: Object Test does not exist

SQL> DESC TEST1 name is empty? Type ----------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------- ------ Userid Not Null Number (38) Loginid Not Null Varchar2 (20) Name1 Varchar2 (20) Password Varchar2 (20) STATUS Char (1) ExpiredDate Date Memo varcha2 (50) ExchangeId Not Null Number (5) PASNUMBER VARCHAR2 (20) SQL> SPOOL OFF

转载请注明原文地址: http://www.9cbs.com/read-132822.html

New Post(0)