u012924422的专栏

Oracle使用正则表达式4种函数：1.regexp_like2.regexp_substr3.regexp_instr4.regexp_replace举例：student表：语句：select regexp_substr(t.code,'[^,]+',1,rownum) as agentcode from student tconnect by rownum<=regexp_count(t.code,'[^,]+')执行结果：值 描述..

第一步:下载DLL;下载地址：https://www.oracle.com/database/technologies/odac-downloads.html第二步：在程序中引用Oracle.ManagedDataAccess.dll，删除之前引用的DataAccess.dll;注意事项：64位 Oracle.ManagedDataAccess.dll同时支持32位和64位winform程序； 下载12.2c版本的Oracle.ManagedDataAccess.dll可以访问..

declarevl_num number(8);SQL_create varchar2(1024);beginselect count(*) into vl_num from tabs where table_name='TestTB';if ( vl_num = 0 ) thenSQL_create := 'create table TestTB(ID int,Name varchar(20) default('' ''))';execute immediate SQL_create;en

declarecursor mycur is select prefix,no,sum(weight)whsweight from GJC_WAREHOUSE group by prefix,no;begin for myrecord in mycur loop update GJC_MAWB b set b.weight=myrecord.whsweight where b.prefix=myrecord.prefix and b.no=myrecord.no; ...

查询本地oracle客户端安装路径下是否有“”4“”文件目录，因为有些程序引用了4.0版本的Oracle.DataAccess.dll，如果只有2.x文件一般是oracle客户端有问题，需要再安装一个有“4”文件目录的oracle客户端，然后程序中引用4文件夹下的Oracle.DataAccess.dll。...