摘要:
package com.ad.web.servlet.common; import java.util.Collection; import java.util.HashMap; import java.util.LinkedList; import java.util.Map; public cl 阅读全文
摘要:
SELECT /*+ rule */ s.username, decode(l.type,'TM','TABLE LOCK', 'TX','ROW LOCK', NULL) LOCK_LEVEL, o.owner,o.object_name,o.object_type, s.sid,s.serial 阅读全文
摘要:
insert into cop_menu (MENU_ID, MENU_NAME, PARENT_ID, ICON_URL, URL, MENU_ORDER, MENU_CODE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_B 阅读全文
摘要:
declare l_cust_id number(10) := 0; l_person_id number(10) := 0;begin DBMS_OUTPUT.ENABLE(buffer_size => null); --表示输出buffer不受限制 for lr in (SELECT temp. 阅读全文
摘要:
CREATE OR REPLACE PACKAGE BODY COP_CUST_POOL_PKG IS FUNCTION get_lock_status(P_CUST_PARTY_ID IN NUMBER, P_person_Id IN NUMBER) RETURN VARCHAR2 is v_fl 阅读全文
摘要:
1.SELECT qyv.*, get_cop_person_group_name(fresp_person_id) groupName, get_person_last_name(fcperson_id) as cperson FROM (select ROW_NUMBER() OVER(PART 阅读全文