ORACLE INSERT INTO

@@  jojoy's memo  @@

Syntax:

INSERT INTO DEST_TABLE(COLUM) SELECT COLUM FROM SOURCE_TABLE;

example :

Insert Into comm_goods_image(goodsid,flag) select a.TYPEID,3 from food_types a;