dsbjoe的专栏

select instr('joe','j') from dual --1    1、字符串位置查找   找不到返回null 2、字符串截取--substr(str,pos[,len]) select substr('joealicia',4,6) from dual --alicia select substr('joealicia',4) from dual ...

场景:从ORACLE A  同步表到ORACLE B   一、创建database link(B端) create public database link dblink_name connect to A_user_name identified by A_user_password using '(DESCRIPTION = (ADDRESS_LIST = ...