Oracle \ SQL - Duplicar Tabela

Oracle:

CREATE TABLE ZGCOLIGADA AS
SELECT *
FROM GCOLIGADA
WHERE CODCOLIGADA = 1


SQL:

SELECT * INTO ZGCOLIGADA
FROM GCOLIGADA
WHERE CODCOLIGADA = 1