select 한것을 insert 하기

select 한것을 insert 하기

(DB)오라클

INSERT INTO insert_tab

select code,

  nm,

  day,

  stand

from

(with t as (

 select 'GB' code, 'AAA' nm, '18/1' day, 'ALL' stand from dual union all

 select 'GB' code, 'AAA' nm, '18/1' day, '5' stand from dual union all

 select 'GB' code, 'AAA' nm, '18/1' day, '2' stand from dual)

 select code,

   nm,

   day,

   stand

 from t)