摘要:
1、在以上图中使用系统进程PID查询对应的物理地址 SELECT v.addr,v.* FROM v$process v WHERE v.SPID = ‘’5256; 2、通过该物理地址查找对应的SQL_ID SELECT t.SQL_ID,t.* FROM v$session t WHERE t. 阅读全文
摘要:
function changeTimelyFlag(){ var date1 = GetXFormFieldValueById('fd_arrival_date'); /*到达日期id*/ var date2 = GetXFormFieldValueById('fd_current_date'); /*当前日期id*/ var dateStartMillo... 阅读全文
摘要:
insert into CUX_ADMINISTRATION_REGION(region_code,region_name,region_level,parent_region_code) values (110000,'北京市',1,0); insert into CUX_ADMINISTRATI 阅读全文
摘要:
DELETE FROM cux_temp t WHERE t.name_id IN ( SELECT c.name_id FROM cux_temp c GROUP BY c.name_id HAVING COUNT(c.name_id) > 1) AND ROWID NOT IN ( SELECT min(c.... 阅读全文