Oracle中对表的操作

表的创建与管理

创建表：

CREATE TABLE TABLE_NAME

(

                COLUMN_NAME TYPE [DEFAULT VALUE],

                COLUMN_NAME TYPE [DEFAULT VALUE],

                COLUMN_NAME TYPE [DEFAULT VALUE],

                … …

                … …

                COLUMN_NAME TYPE [DEFAULT VALUE]

);

重命名表:

RENAME OLD_TABLE_NAME TO NEW_TABLE_NAME;

克隆表:

CREATE TABLE TABLE_NAME AS (SELECT * FROM TABLE_NAME);

删除表:

DROP TABLE TABLE_NAME;

永久删除表:

DROP TABLE TABLE_NAME PURGE;

闪回:

FLASHBACK TABLE TABLE_NAME TO BEFORE DROP;

清空回收站:

PURGE RECYCLEBIN;

 

修改表结构(不建议使用)

增加数据列:

ALTER TABLE TABLE_NAME ADD

(

                COLUMN_NAME TYPE [DEFAULT VALUE],

                COLUMN_NAME TYPE [DEFAULT VALUE],

                … …

                … …

                COLUMN_NAME TYPE [DEFAULT VALUE]

)

 

修改表数据列:

ALTER TABLE TABLE_NAME MODIFY

(

                COLUMN_NAME TYPE [DEFAULT VALUE],

                COLU

MN_NAME TYPE [DEFAULT VALUE],

                … …

                … …

                COLUMN_NAME TYPE [DEFAULT VALUE]

)；

 

删除表数据列:

ALTER TABLE TABLE_NAME DROP COLUMN COLUMN_NAME