摘要：declare evtid varchar2(40); --19mincounts number(5);XString varchar2(3000);YString varchar2(3000);i number;rs1 varchar2(3000);---type record_sgt_col i... 阅读全文

摘要：备忘下，执行sql 报ora 03113，跟踪报 ora 7445调整了下同义词用的关联顺序。同义词用的dblink，就ok了。 阅读全文

摘要：REGEXP_SUBSTR函数格式如下：function REGEXP_SUBSTR(String, pattern, position, occurrence, modifier)__srcstr ：需要进行正则处理的字符串__pattern ：进行匹配的正则表达式__position ：... 阅读全文

摘要：merge into a5_org ausing (select path, lPad(row_number()over(partition by P_departmentID order by dep_order),2,'0') rn from a5_org b where b.d_level=4... 阅读全文

摘要：oracle 支持中文schema名字创建VPD用户createuser采油三厂identifiedbyvpd;grantresource,connect,dbato采油三厂;如果没权限grantexecuteONDBMS_RLStodqa5;创建表createtablesys_department... 阅读全文

摘要：1. insert delete成功，update失败supplementallog没有开源端:GGSCI (OGG1) 32>add trandata gg.tab目标端：GGSCI (OGG2) 32>add trandata regg.tab2. oracle 11.2。0。4 要打开ENAB... 阅读全文

摘要：DECLARE e_name VARCHAR2(50); --声明变量e_namebeginfor names in (select tablenames from codetable) loop dbms_output.put_line('create tabl... 阅读全文

摘要：oraclegoldengate，主站是oracle 10.2.0.5.0，目标库是 11.2.0.1.0，详细配置如下：由于主从数据库版本不一致(OS都是linuxx86-64)，下载的安装包也不一样1.解压并安装gg：主数据库：fbo_ggs_Linux_x64_ora10g_64bit.zip... 阅读全文

摘要：declare str varchar2(1000):='aas,,ss'; sign varchar2(10):=','; currentIndex number; startIndex number; endIndex number; type str_type is table of varchar2(30) index by binary_integer; arr str_type; begin currentIndex := 0; startIndex := 0; loop currentIndex := c... 阅读全文

摘要：Create table Merge_test( LB varchar2(10), DES varchar2(20))insert into Merge_testvalues( 'd',null..........);commit;格式如下--合并数据SELECT LB, LTRIM(MAX(SYS_CONNECT_BY_PATH(DES, ',')), ',') B FROM (SELECT LB, des, ROW_NUMBER() OVER(PARTITION BY LB ORDER BY LB DESC) RN FROM Me... 阅读全文

摘要：CREATE TYPE datetabletype as object ( dates date);CREATE TYPE datetable AS TABLE OF datetabletype;create or replace function REP_GETDATELIST(ConfigID in number)return datetable pipelined is Startdate date; Enddate Date; Startdatestr varchar2(10) ; Enddatestr varchar2(10) ; YEARs varchar2(4):='20 阅读全文