ORACLE表数据的复制与回粘
- 表数据的复制
CREATE TABLE CPU_COPY AS SELECT * FROM CPU; 表数据的回粘
INSERT INTO CPU(CPUNO,COMPUTERNO,BUYTIME,CPUMODEL,PRICE) SELECT * FROM CPU_COPY;表结构
表数据的回粘
INSERT INTO CPU(CPUNO,COMPUTERNO,BUYTIME,CPUMODEL,PRICE) SELECT * FROM CPU_COPY;
表结构