Oracle
Oracle工具使用
weixin_38929027
这个作者很懒,什么都没留下…
展开
-
Oracle 字符串逗号分割转多行
select * from org_orgswhere pk_org in (SELECT regexp_substr(t.pk_org_apply,’[^,]+’,1,ROWNUM) AS orgFROM hrss_hi_household_master tCONNECT BY ROWNUM<=LENGTH (t.pk_org_apply) - LENGTH (regexp_replace(t.pk_org_apply, ‘,’, ‘’))+1)原创 2022-01-11 10:51:49 · 420 阅读 · 0 评论 -
Oracle 自定义表变量使用
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”原创 2021-04-26 17:17:15 · 472 阅读 · 0 评论 -
Oracle 自定义函数查询所有父节点
方法一CREATE OR REPLACE FUNCTION F_FIND_ORG_PARENT_LIST(I_ROOT_ID IN varchar2)return varchar2ISV_PARENT_STR varchar2(4000) ;BEGINselect WMSYS.WM_CONCAT(m.PARENT_ORG_ID) INTO V_PARENT_STRfrom t_eap_sys_organization mstart with ORG_ID = I_ROOT_IDconn原创 2021-03-17 16:02:13 · 138 阅读 · 0 评论 -
Oracle数组
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 mFOR i IN 1 … V_REF原创 2020-12-10 09:34:15 · 151 阅读 · 0 评论 -
Oracle链接参数配置
搜索找到tnsnames.ora文件,添加参数打开文件添加参数,格式如下:DBSAP =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.26.175.200)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = DBSAP)))保存,链接...原创 2020-02-27 09:57:30 · 1219 阅读 · 0 评论