insert into user_login_group sg(user_login_id,group_id,from_date)
select ul.user_login_id,'BUGOWNER',sysdate
from user_login ul
inner join boms.party_relationship pr on pr.party_id_to=ul.party_id
inner join party pa on pa.party_id=ul.party_id
where pr.party_id_from in('10000','10001','10002','10004','10005','10006','10007')
and ul.enabled='Y'
and pa.status_id ='PARTY_ENABLED'
select 'insert into EMPL_POSITION (POSITION_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID)
values ('|| '''Req_BZ''' ||','
|| 'sysdate,null,null, sysdate, sysdate, sysdate,sysdate,'||''''|| pr.party_id_to|| '''' ||');' sr
from boms.party_relationship pr
where pr.party_id_to in('2194');
select ul.user_login_id,'BUGOWNER',sysdate
from user_login ul
inner join boms.party_relationship pr on pr.party_id_to=ul.party_id
inner join party pa on pa.party_id=ul.party_id
where pr.party_id_from in('10000','10001','10002','10004','10005','10006','10007')
and ul.enabled='Y'
and pa.status_id ='PARTY_ENABLED'
select 'insert into EMPL_POSITION (POSITION_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID)
values ('|| '''Req_BZ''' ||','
|| 'sysdate,null,null, sysdate, sysdate, sysdate,sysdate,'||''''|| pr.party_id_to|| '''' ||');' sr
from boms.party_relationship pr
where pr.party_id_to in('2194');
select ul.user_login_id,'BUGOWNER',sysdate
from user_login ul
inner join boms.party_relationship pr on pr.party_id_to=ul.party_id
inner join party pa on pa.party_id=ul.party_id
where pr.party_id_from in('10000','10001','10002','10004','10005','10006','10007')
and ul.enabled='Y'
and pa.status_id ='PARTY_ENABLED'
查询出来的数据插入到user_login_group sg表中.
2:生成插入的脚本
http://blog.csdn.net/chinahuyong
我是SQL菜鸟盲人级的,临阵磨枪中..还有一事不明,values ('|| '''Req_BZ''' ||','
|| 'sysdate,null,null, sysdate, sysdate, sysdate,sysdate,'||''''|| pr.party_id_to|| '''' ||')
插入的值不都是在单引号里括着么,怎么单引号对不上数了..这里面的||是什么东西了,看的我一头晕眼花
决心整本SQL书,彻底狠嗑一番!
这是Oracle的语法字符串加起来了第一个语句是SQL-92 标准写法在Oracle\MSSQL等都是可行的