摘要:
CREATE OR REPLACE FUNCTION get_cop_project_owners(p_project_id NUMBER) RETURN VARCHAR2 IS l_owers VARCHAR2(500); CURSOR cur_owner IS SELECT ppf.full_n 阅读全文
摘要:
WITH person AS (SELECT ppf.person_id, ppf.last_name FROM per_people_f ppf WHERE 1 = 1 AND trunc(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effe 阅读全文
摘要:
CREATE OR REPLACE FUNCTION get_cop_person_group(p_person_id NUMBER) RETURN NUMBER IS l_group NUMBER; l_dept_name VARCHAR2(240); CURSOR cur_dept(t_grou 阅读全文