oracle
勤读意现
我希望自己更强大
展开
-
oracle19配置好以后本电脑可以使用,同局域网其他电脑访问就会报15241解决-------gxl
数据安装完成以后其他电脑不能调用处理办法原创 2022-10-12 14:23:34 · 406 阅读 · 0 评论 -
开启oracle指定sid服务
开启oracle指定实例原创 2022-06-30 13:16:15 · 601 阅读 · 0 评论 -
,ORA-04091: 表 xxxx 发生了变化, 触发器/函数不能读它,及ORA-06519----------gxy
数据库处理原创 2022-04-08 12:02:38 · 454 阅读 · 0 评论 -
oracle判断值是否为数字
select count(1) into x_Nums from dual where regexp_replace(substr(x_OrainCode, -x_Flownum),'^[-\+]?\d+(\.\d+)?$','') is not null;如果是0 那就是数字,不然那就是非数字原创 2021-08-10 09:04:48 · 1010 阅读 · 0 评论 -
根据特定字符拆分字符串,形成数据--------------------------gxy
CREATE OR REPLACE TYPE ty_str_split IS TABLE OF VARCHAR2 (4000)FUNCTION fn_split(p_str IN CLOB, p_delimiter IN VARCHAR2) RETURN ty_str_split IS str VARCHAR2(4000); str_split ty_str_split := ty_str_split(); x_length Integer;原创 2021-07-06 08:56:39 · 80 阅读 · 0 评论 -
创建定时任务-oracle--------------gxy
DECLARE p_project_statis_job number;Begin dbms_job.submit(job =>p_project_statis_job,what => 'zsjwh.insertyryfpsvalue(8888);',next_date => to_date('17-04-2021 11:30:00', 'dd-mm-yyyy hh24:mi:ss'),interval => 'SYSDATE+30/(60*24)'); Commit;原创 2021-04-17 11:53:33 · 81 阅读 · 0 评论 -
oracle存储过程创建-----gxy
存储过程创建------------------------------1create or replace procedure wf_obj_insert_gctk(p_in_wfid in integer,p_in_projcode in varchar2,p_in_banme in varchar2) as p_ffrdid integer;---项目文件夹ID p_zfrdid integer;---项目下文件夹ID p_idpath varchar2(100);---实际的I原创 2020-11-05 15:07:33 · 128 阅读 · 0 评论 -
oracle 字符串转数组
SELECT distinct REGEXP_SUBSTR(t.llbm1, ‘[^;]+’, 1, LEVEL, ‘i’) AS STR FROM user_nbgzlld t, cpcshtins s where t.shtinsid = s.shtinsid and s.wfid = 35 connect by level<= (regexp_count(t.llbm1,’;’)+1)原创 2020-07-29 17:05:03 · 301 阅读 · 0 评论 -
oracle存储过程调用及创建----------------gxy
创建(带参数):create or replace procedure saveMaterial( obj in varchar) as cursor ivv is select * from user_sjlr_sub i where i.shtinsid = obj and not exists (select 1 from user_material_sub b where ...原创 2019-01-30 10:22:58 · 178 阅读 · 0 评论