insert into selectで、

 レコードの抽出コピーする。

insert into table_name (col1, col2, ...)

select col1, col2, ... from table2_name;



insert into O_IKO_TO

(

ITEM01

)

select TABLE_NM as nm

from O_IKO_FROM

Next Post Previous Post
No Comment
Add Comment
comment url