select t.id ,t.gdtype,t.tsfrom, '1' as type from COMPLAINTS t where t.tsfrom='QQ'
union
select t.id ,t.gdtype,t.tsfrom, '2' as type from COMPLAINTS t where t.tsfrom='QQ';
SELECT distinct new CustomManage(cpdescribe) FROM CustomManage C WHERE C.cpdescribe IS NOT NULL
select * from cpdescribe from CUSTOMMANAGE c where c.cpdescribe is not null ;
select * from comp_disposal;
select * from complaints_assign;
select * from COMP_DISPOSAL c;
select count(M.Contact) from COMPLAINTS M where M.Contact = '符丽娟'
select * from MEMBER_INFOS m where m.xm='符丽娟';
select * from MEMBER_INFOS c where c.;
select * from COMPLAINTS for update
select count(c.contact) from COMPLAINTS c where c.contact='符丽娟'
select * from COMP_DISPOSAL for update ;
select
distinct custommana0_.khname as col_0_0_
from
custommanage custommana0_
where
custommana0_.khname is not null
201381002
select *from Complaints c ,COMP_DISPOSAL s where c.gdid = s.gdid
select count(*) from Complaints c ,COMP_DISPOSAL s where c.gdid = s.gdid
select * from COMPLAINTS c
select MAX(c.gdid) from COMPLAINTS c
select TO_CHAR(SYSDATE(),'YY/MM/DD HH24:MI:SS);
select to_char(sysdate,'yy-mm-dd hh24:mi:ss') from dual
select gdid from Complaints c where c.GDTIME like to_date('2013-7-22','yyyy-mm-dd') order by c.ID
select
complaints0_.gdid as col_0_0_
from
complaints complaints0_
where
complaints0_.gdtime like to_date('2013-07-22','yyyy-mm-dd')
order by
complaints0_.id desc
select * from Complaints
select s.hyzcm from MEMBER_INFOS s;
select * from COMPLAINTS for update;---对表的数据进行编辑
select C.CPNAME from CUSTOMMANAGE C WHERE C.CPNAME IS NOT NULL GROUP BY C.CPNAME;
select distinct c.cpname from CUSTOMMANAGE C WHERE C.CPNAME IS NOT NULL;
select c.contact,c.telphonenum from COMPLAINTS C where c.hyid = '15645874587'
SELECT C.CPNAME FROM CustomManage C WHERE C.cpname IS NOT NULL GROUP BY cpname
select c.cpdescribe from CUSTOMMANAGE c where c.cpname is not null and C.cpname='酒店' order by cpdescribe DESC;
select * from company t where t.name = '张三';
select cpdescribe from CustomManage c where c.cpname is not null and c.cpname='MSN'
TRUNCATE TABLE COMPLAINTS ;
select * from COMPLAINTS e ,COMP_DISPOSAL c where e.GDID = c.GDID;
select * from COMPLAINTS for update
update COMPLAINTS t set t.REPLYTIME = '2013-08-05'
select * from t_users r where r.name='';
update COMPLAINTS c set c.cjrid =
select * from comp_disposal
commit;
select * from COMPLAINTS c for update where c.id=10025;
select * from COMP_DISPOSAL for update;
select c.DEAL_STATUS from COMP_DISPOSAL c where GDID=2013723002
select * from Company;
truncate table COMPLAINTS ;
select * from MEMBER_INFOS
select t.id from CUSTOMMANAGE t where t.id = 10012
update CUSTOMMANAGE t set CUSTOMMANAGE.Cpname = '' where t.id=10025;
update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;
update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;
update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;
update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;
update COMPLAINTS t set t.PRODUCTTYPE = 10010 where t.id=10010;
select * from CUSTOMMANAGE t where t.khname is not null;
select *from member_infos t where t.hyzcm='tp10000805'
select * from COMPLAINTS for update;
select * from comp_disposal
BURDEN_ASSOCIATE
select * from
select* from COMPLAINTS for update
===insert into B(字段名)(select 字段名 from A)
insert into COMPLAINTS(ISCONCLUDED)(select ss.DIFF_LEVEL from COMP_DISPOSAL ss,COMPLAINTS s where s.GDID = ss.GDID and ss.DIFF_LEVEL is not nul);
select * from COMP_TURN_CONFIG t where t.GDID = '2013829003'
select
compturnco0_.id as id40_,
compturnco0_.deal_dept as deal2_40_,
compturnco0_.deal_person as deal3_40_,
compturnco0_.deal_status as deal4_40_,
compturnco0_.end_tache as end5_40_,
compturnco0_.end_time as end6_40_,
compturnco0_.gdid as gdid40_,
compturnco0_.open as open40_,
compturnco0_.operate_time as operate9_40_,
compturnco0_.operator as operator40_,
compturnco0_.postil as postil40_,
compturnco0_.remind as remind40_,
compturnco0_.send as send40_,
compturnco0_.send2 as send14_40_,
compturnco0_.start_tache as start15_40_,
compturnco0_.start_time as start16_40_,
compturnco0_.state as state40_,
compturnco0_.tache as tache40_,
compturnco0_.timelimit as timelimit40_,
compturnco0_.type as type40_
from
comp_turn_config compturnco0_
where
compturnco0_.gdid='2013829006'
select * from COMP_DISPOSAL a where a.DEAL_INFO = '处理完毕'
SELECT * FROM COMP_DISPOSAL WHERE DBMS_LOB.INSTR(comp_disposal.DEAL_INFO,'处理完毕',1,1)>0;
select * from COMP_TURN_CONFIG where gdid = '2013828102'
select * from COMP_APPROVE_OPINION t where t.GDID = '2013829006'
select * from COMP_TURN_CONFIG t where t.GDID = '2013829002'
select * from COMPLAINTS w where w.gdid = '201396001'.
select * from COMPANY C where C.lxrdh='15889614442' and C.ssgj=''