weixin_38929027的博客

select * from org_orgs where pk_org in ( SELECT regexp_substr(t.pk_org_apply,’[^,]+’,1,ROWNUM) AS org FROM hrss_hi_household_master t CONNECT BY ROWNUM<=LENGTH (t.pk_org_apply) - LENGTH (regexp_replace(t.pk_org_apply, ‘,’, ‘’))+1 )

CREATE OR REPLACE TYPE “IMP_MAP_TYPE” AS OBJECT(ID nvarchar2(36),NAME nvarchar2(60),VAL nvarchar2(100)) CREATE OR REPLACE TYPE “IMP_MAP_TABLE”

方法一 CREATE OR REPLACE FUNCTION F_FIND_ORG_PARENT_LIST (I_ROOT_ID IN varchar2) return varchar2 IS V_PARENT_STR varchar2(4000) ; BEGIN select WMSYS.WM_CONCAT(m.PARENT_ORG_ID) INTO V_PARENT_STR from t_eap_sys_organization m start with ORG_ID = I_ROOT_ID conn

TYPE t_table IS TABLE OF VARCHAR2(36) INDEX BY BINARY_INTEGER;–字符串可变数组 V_REF_PART_IDS t_table; V_REF_PART_ID VARCHAR2(50); BEGIN –bulk collect INTO 数组赋值 SELECT m.REF_PART_ID bulk collect INTO V_REF_PART_IDS FROM CM.T_CM_BU_REF_PART m FOR i IN 1 … V_REF

搜索找到tnsnames.ora文件,添加参数 打开文件 添加参数,格式如下: DBSAP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.175.200)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DBSAP) ) ) 保存,链接...