sustwct的专栏

memoSELECT o.cname,s.login_id FROM operator_t o,staff_t s where o.login_id=s.login_id and s.org_id='ORG0119';

更新的值为：'1461','1462','1501','1463','1464','1465','1466','1467','1468','1469','1470','1471','1472','1481'update sys_user set  localids='''1461'',''1462'',''1501'',''1463'',''1464'',''1465'',''1466'','

select * from tab where tname=upper('ITIL_ROTA_DUTY_VIEW');    select * from tab where tname=upper('itil_rota_duty');         select * from tab where tname=upper('itil_rota_timeperiods');  selec

insert into sys_user_role(roleid,userid) select roleid,userid from sys_tmp;多行插入insert into sys_user_role(roleid,userid)  select roleid,'$B' userid  from  sys_user_role where userid='$A';

two way:roleid列并不在表sys_user中，虚拟roleid列，指定roleid列的值均为aaa，以下两种方式实现。1.username 为表sys_user中存在的列。select userid,replace(username,username,'aaa') as roleid from sys_user ;2.select userid,'aaa'

select * from orders where order_date

SELECT * FROM service_request_t where create_time >='2012-02-02 00:00:00' and siteid='8'and creator='STAFF00707';update service_request_t set owner_group='group20120314000089',siteid='22'  where

for exampleSELECT * FROM ci_info_t where station_id='STA0623';update ci_info_t set station_id='STA0629' where station_id='STA0623';update station_t set station_id=replace(station_id,

SELECT * FROM staff_t where person_id='P2012023031' or person_id='P2012023034';

delete from  person_t where id='P2012023031';

用系统中的wm_concat函数实现：select  wm_concat(table_name) from user_tables;