INSERT INTO t_admin_rms_yhygwgxb select sys_guid() AS XH,ID,'201202160931191071ae0a5d79421999c8009e731641e6' GWXH, 'SYSTEM' CJR,SYSDATE CJSJ,'','' from V_ADMIN_USER_HBJ_TREE WHERE TARGET IS NOT NULL;INSERT INTO t_admin_rms_yhygwgxb select sys_g
阅读背景：
Oracle通过Select语句来插入数据
来源：互联网
分享到：
