鲜橙多的博客

一.##查看正在运行+历史运行过的容器docker ps -axianwangfudeMacBook-Air:~ brandonxian$ docker ps -aCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS

语法逻辑：open [cursor] for [query_code] for [para1,para2…]下文中的例子：=2 就是第一个参数名；-- Created on 12/18/2020 by BRANDONXIAN declare type c_refcur is ref cursor; c_data c_refcur; l_str varchar2(100):='select 1 ids fr

declare type rowt_test is table of sf_org%rowtype index by binary_integer ;t_tab rowt_test;tcount number;cursor c_name(parents in number) is select org_id,org_name,parent_id from sf_org where parent_id =parents;begin t_tab.delete;for i i.

oralce的package由 包头和包体构成；包头声明要做的事情，包体做具体的实现，话不多说直接上代码：create or replace package pkg_firste_test as procedure p_update_lable(v_id in number);function addid(x in number,y in number) return number ;end ;-- -----------------------------------------

windows：进入mysql查看字符编码：show variables like "%char%"；一般来说是 databases 和server 两项是lantin1的编码集修改mysql的字符集： mysql> set character_set_client=utf8; mysql> set character_set_connection=utf8; mysql> set character_set_d.

一. 需求： 每天循环更新表的数据量create or replace PROCEDURE TEST /*作者：盈欢时间：2020/08/21*/AS COUNTS NUMBER ;SQLMSG VARCHAR2(100); CURSOR COR_LIST_STG IS SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER ='STG'; CURSOR COR_LIST_ODS IS SELECT TABLE_NAME FROM ALL

DELETE FROM TMP_VLOAN_CLIENT_INVITECODE A WHERE EXISTS (SELECT 1 FROM (SELECT LOGINID,COUNT(1) FROM TMP_VLOAN_CLIENT_INVITECODE GROUP BY LOGINID HAVING COUNT(1)>1 ) B WHERE A.LOGINID=B.LOGINID ) AND A.NAME IS NULL ;解释：delete from中 exist 和 and 和

问题：当我想将oracle表的数据某个字段附上自增id的并插入到某个表中时候，我进行了如下的操作：INSERT INTO STG_DICT(ID,STG_TABNAME)select SEQ_STG_DICT.NEXTVAL ID,STG_TABNAME FROM USER_TABLES WHERE TABLE_NAME NOT IN('STG_DICT','CODE','TMP_DIFF') ORDER BY TABLE_NAME;发现此时出现报错，单独执行查询的sql也是一样

针对oracle数据库做数据迁移或者定时任务时，会存在一些字段多，数据量大的情况，使用单单使用 insert into …select 语句有可能会导致运行时间长，且运行不成功的情况1） 选择字段使用 游标进行分组，将数据分为 x 份（依据分组而定）2） ...