Oracle根据结果集创建新表

--复制整表
CREATE TABLE trp_advp_copy AS 
SELECT
    *
FROM
    trp_advp

--复制表的部分列
CREATE TABLE trp_advp_copy AS 
SELECT
    id,
    advpnumber,
    groupname,
    projectname 
FROM
    trp_advp

--复制表的部分列并取别名
CREATE TABLE trp_advp_copy (a,b,c,d) AS 
SELECT
    id,
    advpnumber,
    groupname,
    projectname 
FROM
    trp_advp