Oracle根据结果集创建新表

–复制整表
CREATE TABLE A AS
SELECT
*
FROM
B

–复制表的部分列
CREATE TABLE A AS
SELECT
id,
name,
sex
FROM
B

–复制表的部分列并取别名
CREATE TABLE A (a,b,c) AS
SELECT
id,
name,
sex
FROM
B