桃子1007-CSDN博客

原创 Oracle函数

--拼接select concat(concat('''','88888888'),'''') 连接 from dual; --'88888888'--首字母大写select initcap('hello lay') upp from dual;--Hello Layselect NLS_INITCAP('hello lay') upp from dual;--小写select lower('AaBbCcDd') AaBbCcDd from dual;--aabbccdd--拼接填充sele

2021-02-05 14:54:50 80

原创触发器增删改

-- 增加部门时，且READ_PLM为0触发sys_015增加create or replace trigger hr_015_insertbefore insert on hr_tuo2for each rowDECLARE PRAGMA AUTONOMOUS_TRANSACTION; sour number:=0; parenid varchar2(20); begin :new.dept_id_copy := :new.dept_id; parenid:=

2020-08-06 16:05:07 224

原创定编定岗

自己看select z.one as one, z.two as two, z.three as three, z.pk_org as pk_org, z.pk_group as pk_group, org.name as orgname, z.postname as postname, TRIM (Replace(to_char(wmsys.wm_concat(z.trueclass||' ')),',',' ')) as trueclass,

2020-07-16 11:12:26 173

原创 NC点击按钮若没有数量则会抛异常

列表package nc.ui.dm.m4804.action;import java.awt.event.ActionEvent;import nc.bs.framework.common.NCLocator;import nc.itf.dm.feecalculate.deliv.IDelivCalculate;import nc.ui.dcm.chnlrplstrct.maintain.action.MessageDialog;import nc.ui.pubapp.uif2app..

2020-07-14 10:23:26 455

原创点击审批后新建一张采购订单，并将自动生成的应收单dr转为1，单据号的生成，查增改

package nc.ui.dm.m4812.action;import java.awt.event.ActionEvent;import java.text.SimpleDateFormat;import java.util.Date;import java.util.HashMap;import nc.bs.framework.common.NCLocator;import nc.itf.uap.IUAPQueryBS;import nc.itf.uap.IVOPersistence

2020-07-14 10:17:23 489

原创触发器，新增一条数据将其中的俩个字段写到另一张表对应的字段

CREATE OR REPLACE TRIGGER wastage_testBEFORE INSERT ON ic_wastage_b for each rowdeclare PRAGMA AUTONOMOUS_TRANSACTION; begin UPDATE dm_delivbill_b SET nsignastnum=:new.noutsignastnum,nsignnum=:new.noutsignnum where cfirstbid=:new.cfirstbillbid;

2020-07-14 10:12:47 829

原创触发器，新增本条数据后再修改本条数据的一个字段

create or replace trigger modify_testbefore INSERT ON ia_iabill_b for each row begin SELECT a.name INTO :new.新增本条数据的一个字段 from ia_iabill iabill left join ( select distinct flow.pk_org,flow.cmaterialvid,defdo

2020-07-14 10:10:32 1215

原创 ora利用触发器插入一条数据后，再查询出相关名称后修改新插入的数据

ora利用触发器插入一条数据后，再查询出相关名称后修改新插入的数据create or replace trigger 触发器名before INSERT ON 表 for each row begin SELECT a.name（表的字段） INTO :new.vbdef1（要改变的字段） from ia_iabill iabill left join ( select distinct flow.pk_o

2020-06-29 12:00:18 637

原创 dblink跨服务器转移数据存储过程

dblink跨服务器转移数据存储过程create or replace procedure 存储过程名 as begin for x（变量） in (select id, DESCRIPTION, PARENT_ID, DEPT_ID from 表1 where READ_PLM=0 or READ_PLM is null) loop insert into 表2@dblink (CGROUPID, CGROUPNAME, CPARENTGROUPID, grou

2020-06-29 12:00:02 383

原创 ora左关联查询

左关联，case when，每月的销量select a.pk_group as pkgroup, a.pk_org as pkorg, a1.name as ename, dept.name as dept, person.name as person, customer.name as customer, material.name as material, mm.name as mm, b.vfree1 as

2020-06-29 11:59:37 253

app10071128的博客