学习笔记-ORACLE-WITH AS（oracle with as insert）

将with as 结果 插入表中

INSERT INTO AAA

WITH TEMP_AAA AS (

SELECT * FROM AAA WHERE DATA_ID ='1'

UNION ALL

SELECT * FROM AAA WHERE DATA_ID ='2'

)

SELECT * FROM TEMP_AAA;