摘要:
1 CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000); 2 3 create or replace function strsplit2(p_value varchar2, p_split varchar2 := ',') 4 return str_split 5 pipelined is 6 v_idx ... 阅读全文
摘要:
1 WITH RPL (FId,Fname,Forder) AS 2 ( 3 SELECT ment.deptno,ment.deptname,ment.orderno 4 FROM JTERP..fg_department ment 5 WHERE ment.deptno in ( 6 select mdept_mid from d... 阅读全文