qq_33458228的博客

转载：https://blog.csdn.net/LL596214569/article/details/77971770一、下载官网下载地址: https://www.oracle.com/downloads/index.html#menu-downloads或者：链接：http://pan.baidu.com/s/1cGr3PW密码：oz8n下载解压后得到：三个安装包:PL/SQL Devel...

树状图复制功能 ：写了一个存储过程create or replace procedure copy_TemplateDetail(sourceId number, --源idu_id number, --更新的idu_createUser varchar2) is new_one_id number; new_two_id number; one_level nu...

第一种insert into userapplyRecord (id,userid,type,applyId,createUser,createDate) select S_USERAPPLYRECORD.NEXTVAL,2352,'moduleSetUp',applyid,'guishan',to_date('2019-04-09 10:18:16','yyyy-mm-dd...