qq_39365424的博客

select t.*from comm_org_code tstart with t.ORG_CODE = ‘C131’connect by t.parent_code = prior t.ORG_CODE–如果把 parent_code 跟ORG_CODE调换一下就是查询所有的父级结果–ORG_CODE parent_code...

//截取字符串：substr(org.org_name,0,instr(org.org_name,‘钻探’,1,1)-1) as branch_comp_name//去除汉字：translate(org1.org_name,’#’|| translate(org1.org_name,‘abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0...

/+IGNORE_ROW_ON_DUPKEY_INDEX(rtoc_rtdata_interrupt_config(rtdata_point_name))P/

SELECT * FROM ALL_DB_LINKS; – 这句语句是查询所有的连接– 下面的语句是新建一个别的库的连接CREATE PUBLIC DATABASE LINK 连接名称 CONNECT TO 登录名 IDENTIFIED BY 密码 USING ‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST ...