萧闹闹

摘要： create or replace function ht_gettopdeptNAME(deptid in varchar) return varchar2 is r varchar2(1024); c int; m varchar2(20); r_f varchar2(1024);begin select a.tree_level_num, a.parent_node_name,a.tree_node into c, r,m from pstreenode a where a.tree_name = 'DEPT_SECURITY' and ... 阅读全文

摘要： create or replace function ht_gettopdeptid(deptid in varchar) return varchar2 is r varchar2(1024); c int; m varchar2(20); r_f varchar2(1024);begin select a.tree_level_num, a.parent_node_name,a.tree_node into c, r,m from pstreenode a where a.tree_name = 'DEPT_SECURITY' and a.... 阅读全文

摘要： create or replace function getUnitFullName(deptid in varchar)return varchar2 isr varchar2(1024);c int;n varchar2(1024);m varchar2(1024);r_name varchar2(1024);m_deptid varchar2(64);beginr := '';select a.tree_level_num,a.tree_nodeinto c,m_deptidfrom pstreenode awhere a.tree_name = 'DEPT_SE 阅读全文

摘要： create or replace function getUnitFullcode(deptid in varchar) return varchar2 is r varchar2(1024); c int; n varchar2(1024); m varchar2(1024); r_name varchar2(1024); m_deptid varchar2(64);begin r := ''; select a.tree_level_num into c from pstreenode a where a.tree... 阅读全文