<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_35201754的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_35201754</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_35201754]]></copyright><item><title><![CDATA[easyui  datagrid editor text事件绑定]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/115211761</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/115211761</guid><author>qq_35201754</author><pubDate>Thu, 25 Mar 2021 16:22:59 +0800</pubDate><description><![CDATA[....
....
&lt;th id="skuCodeId"  field="skuCode" width="150" data-options="editor:
                                    {
                                 type: 'text',
                                 options: {
                                 onClick:f..]]></description><category></category></item><item><title><![CDATA[临时表空间爆满问题]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/105293751</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/105293751</guid><author>qq_35201754</author><pubDate>Fri, 03 Apr 2020 15:12:01 +0800</pubDate><description><![CDATA[参考：http://blog.itpub.net/30036720/viewspace-2121272/

--查看临时表空间


SELECT temp_used.tablespace_name,

 total - used as "Free",

 total as "Total",

 round(nvl(total - used, 0) * 100 /...]]></description><category></category></item><item><title><![CDATA[mysql+ssh]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/103576139</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/103576139</guid><author>qq_35201754</author><pubDate>Tue, 17 Dec 2019 10:53:07 +0800</pubDate><description><![CDATA[Mysql+ssh配置













Mysql+ssh配置

一、Linux平台间mysql+ssh配置

本机地址为:192.168.189.133
mysql服务器地址为:192.168.189.139

linux命令行下使用ssh命令建立SSH隧道
本机上生成ssh public key并复制给Mysql服务器

利用 ssh-keygen 命令，生成本机id_r...]]></description><category></category></item><item><title><![CDATA[oracle xml列转行]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/99412624</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/99412624</guid><author>qq_35201754</author><pubDate>Thu, 29 Aug 2019 17:42:07 +0800</pubDate><description><![CDATA[原来



xml转换：


select * from 
(select cust_coding,delivery_amt,mth from rpt_sales_quota_month  where yearly=2019 and brand_coding='0') 
pivot xml(sum(delivery_amt) for mth in (any))





使用存储过程解析xml...]]></description><category></category></item><item><title><![CDATA[kettle资源库备份]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/100139715</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/100139715</guid><author>qq_35201754</author><pubDate>Thu, 29 Aug 2019 16:07:09 +0800</pubDate><description><![CDATA[存储过程：

在本地使用dblink连接远程表创建物化视图，根据物化视图创建表


create or replace procedure backup_kettle
AUTHID CURRENT_USER
 as
  cursor tbl_cur is
     select table_name as src_table    from all_tables@db_kettle
     wh...]]></description><category></category></item><item><title><![CDATA[mysql触发器问题]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/96975320</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/96975320</guid><author>qq_35201754</author><pubDate>Tue, 23 Jul 2019 11:38:45 +0800</pubDate><description><![CDATA[create trigger t_user_trigger
BEFORE update on t_user
for each row 
begin

   -- insert into tt (id) values(1);
end；

发现把insert into注释了就可以运行，但是又没有什么问题，百度之后发现mysql真坑，将分号当做结束符了，使用delimiter $$定...]]></description><category></category></item><item><title><![CDATA[关于oracle闪回归档的记录]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/92806575</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/92806575</guid><author>qq_35201754</author><pubDate>Thu, 20 Jun 2019 09:36:25 +0800</pubDate><description><![CDATA[1.一些说明：

为了防止一些表出现错误，且为了保证能一定能闪回指定时间的数据，所以需要将闪回归档信息存到表空间中

select flashback_on from v$database

可以看到没有开启，开不开启都没有关系

建立表空间

create tablespace HIS_TBSPACE datefile '/data/pdm/history_data' size 2G;

查询...]]></description><category></category></item><item><title><![CDATA[oracle恢复测试]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/92573830</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/92573830</guid><author>qq_35201754</author><pubDate>Mon, 17 Jun 2019 13:41:25 +0800</pubDate><description><![CDATA[最近做了一次rman的恢复测试，记录一下。

开启两个终端：

rman:rman target /;

sql:sqlplus / as sysdba;

先说一下增量和全量，增量是在全量的基础上做的备份

增量分为差异增量和累计差异增量

差异增量：

备份逻辑：当前level n到最近一次level n 或最近一次小于n期间增加的数据





累计差异增量：

备份逻辑：当前leve...]]></description><category></category></item><item><title><![CDATA[kettle下载windows共享文件夹到本地]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/90669016</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/90669016</guid><author>qq_35201754</author><pubDate>Wed, 29 May 2019 13:06:42 +0800</pubDate><description><![CDATA[1.将jar包导入到kettle的lib目录

下载地址：https://mvnrepository.com/artifact/jcifs/jcifs/1.3.17



2.建立转换



java代码如下：


import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File...]]></description><category></category></item><item><title><![CDATA[做个标记]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/90405120</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/90405120</guid><author>qq_35201754</author><pubDate>Tue, 21 May 2019 13:24:22 +0800</pubDate><description><![CDATA[http://0cx.cc/category/yunwei/

https://blog.youkuaiyun.com/cssxn/article/details/89576953
]]></description><category></category></item><item><title><![CDATA[在pandas.DataFrame.to_sql时指定数据库表的列类型（转载）]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/90177057</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/90177057</guid><author>qq_35201754</author><pubDate>Mon, 13 May 2019 17:17:25 +0800</pubDate><description><![CDATA[在数据分析并存储到数据库时，Python的Pandas包提供了to_sql 方法使存储的过程更为便捷，但如果在使用to_sql方法前不在数据库建好相对应的表，to_sql则会默认为你创建一个新表，这时新表的列类型可能并不是你期望的。例如我们通过下段代码往数据库中插入一部分数据：


import pandas as pd
from datetime import datetime

df = pd...]]></description><category></category></item><item><title><![CDATA[kettle linux调用]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89946764</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89946764</guid><author>qq_35201754</author><pubDate>Wed, 08 May 2019 10:35:31 +0800</pubDate><description><![CDATA[脚本：



#!/bin/bash
last_date=`date +%Y%m%d --date="1 day ago"`
kettle_home=/opt/kettle/pdi-ce-7.1.0.0-12/data-integration
repo=PRD
user_name=admin
passwd=admin
dir=/DATA_CHECK
job=check_done_send_mail...]]></description><category></category></item><item><title><![CDATA[Python库资源大全]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89841857</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89841857</guid><author>qq_35201754</author><pubDate>Sun, 05 May 2019 11:25:55 +0800</pubDate><description><![CDATA[本文是一个精心设计的Python框架、库、软件和资源列表，是一个Awesome XXX系列的资源整理，由BigQuant整理加工而成，欢迎扩散、欢迎补充！

对机器学习、深度学习在量化投资中应用感兴趣的朋友可以直接在BigQuant人工智能量化投资平台上开发策略~~~

本文目录：


 算法和设计模型
 构建工具
 缓存
 代码分析
 命令行工具
 兼容性
 计算机视觉
 并发和并行
 加密
...]]></description><category></category></item><item><title><![CDATA[RMAN记录]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89643324</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89643324</guid><author>qq_35201754</author><pubDate>Mon, 29 Apr 2019 17:01:27 +0800</pubDate><description><![CDATA[rman备份脚本：


##======================================================================
##  
## 
##  
##  usage: db_bak_rman.sh &lt;$ORACLE_SID&gt; &lt;$BACKUP_LEVEL&gt;
##         BACKUP_LEVEL:
##      ...]]></description><category></category></item><item><title><![CDATA[oracle记录2 （收缩表空间）]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89512542</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89512542</guid><author>qq_35201754</author><pubDate>Thu, 25 Apr 2019 11:31:16 +0800</pubDate><description><![CDATA[1.resize表空间

参考：https://blog.youkuaiyun.com/csethcrm/article/details/52181212


select 'alter database datafile ''' || a.file_name || ''' resize ' ||
round(a.filesize - (a.filesize - c.hwmsize - 100) * 0.8...]]></description><category></category></item><item><title><![CDATA[oracle  silent新增实例]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89469514</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89469514</guid><author>qq_35201754</author><pubDate>Thu, 25 Apr 2019 11:27:38 +0800</pubDate><description><![CDATA[代码：

dbca -silent -createDatabase -templateName $ORACLE_HOME/assistants/dbca/templates/General_Purpose.dbc -gdbName stg -sid stg -characterSet ZHS16GBK -sysPassword stg -systemPassword stg -responseFi...]]></description><category></category></item><item><title><![CDATA[hadoop集群搭建+hbase]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89284877</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89284877</guid><author>qq_35201754</author><pubDate>Sat, 13 Apr 2019 16:49:44 +0800</pubDate><description><![CDATA[1.配置jdk

2.复制出两台虚拟机

3.配置hostname(master/slave1/slave2)


vim/etc/sysconfig/network修改hostname




NETWORKING=yes

HOSTNAME=master

4.配置hosts


vim/etc/hosts

192.168.164.129master

192.16...]]></description><category></category></item><item><title><![CDATA[centos 共享文件夹及oracle的表变量]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/89155826</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/89155826</guid><author>qq_35201754</author><pubDate>Tue, 09 Apr 2019 17:42:17 +0800</pubDate><description><![CDATA[1.centos 无密码共享文件夹

(1) 安装samba


yum -y install samba samba-client

(2)修改配置文件


vim/etc/samba/smb.conf




# See smb.conf.example for a more detailed config file or
# read the smb.conf manpage.
# R...]]></description><category></category></item><item><title><![CDATA[oracle报错记录]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/88814401</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/88814401</guid><author>qq_35201754</author><pubDate>Tue, 26 Mar 2019 10:52:50 +0800</pubDate><description><![CDATA[1.ora-01950 对XX表空间没有权限

解决：grant resource to xxx;授予访问资源的权限

2.ora-01034和ora-27101

oracle当前的服务不可用，shared memory realm does not exist

因为oracle没有启动或没有正常启动，共享内存并没有分配给当前实例

解决：(1).exportORACLE_SID=si...]]></description><category></category></item><item><title><![CDATA[Centos7安装Oracle 11gR2]]></title><link>https://blog.youkuaiyun.com/qq_35201754/article/details/88066206</link><guid>https://blog.youkuaiyun.com/qq_35201754/article/details/88066206</guid><author>qq_35201754</author><pubDate>Fri, 01 Mar 2019 19:16:21 +0800</pubDate><description><![CDATA[最近尝试在centos minimal上安装Oracle 11g， 没有图形化界面，总是安装失败，最后在网上找了一个好教程，按照操作终于安装成功，这里转载记录一下：


========================================
-  环境：VM12+centos7 x86_64 minimal　　　　　　　　
-　　最小化安装的Centos7
-　　虚拟机配置
-　　...]]></description><category></category></item></channel></rss>