<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[bantaoti1130的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/bantaoti1130</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; bantaoti1130]]></copyright><item><title><![CDATA[Oracle非分区索引，全局分区索引和本地分区索引。]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773962</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773962</guid><author>bantaoti1130</author><pubDate>Sun, 18 Aug 2019 14:32:00 +0800</pubDate><description><![CDATA[1.如果按照索引是否分区作为划分依据，Oracle 的索引类型可以分为非分区索引，全局分区索引和本地分区索引。

2.创建演示实例

--创建非分区表create table test_partition_01(
number_1 number,
number_2 number,
string_1 varchar2(10),
string_2 varchar2(20)
...]]></description><category></category></item><item><title><![CDATA[CentOS 7 修改root 密码]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773958</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773958</guid><author>bantaoti1130</author><pubDate>Sun, 14 Apr 2019 10:11:00 +0800</pubDate><description><![CDATA[环境：

1.重启系统在加载内核的地方按e，编辑启动脚本

2.将ro crashkernel = auto 所在地的 ro 替换为 rw init=/sysroot/bin/sh
3.修改完成后用Ctrl+x 键来启动单用户模式
4.进入单用户模式后使用chroot /sysroot 对文件进行授权，授权后修改root密码
5.创建 autorelabel文件	touch...]]></description><category></category></item><item><title><![CDATA[Oracle PL/SQL 实现excel PMT函数、PPMT函数]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773959</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773959</guid><author>bantaoti1130</author><pubDate>Thu, 20 Dec 2018 16:15:00 +0800</pubDate><description><![CDATA[PMT函数
1.每月本息金额 = (本金×月利率×(1＋月利率)＾还款月数)÷ ((1＋月利率)＾还款月数-1)

function pmt(in_rate in number,in_term in number default 0,in_financeAmount in number)
    return number is
    
    pmt_result nu...]]></description><category></category></item><item><title><![CDATA[SSM-@Transactional 注释不生效]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773956</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773956</guid><author>bantaoti1130</author><pubDate>Sun, 02 Sep 2018 11:17:00 +0800</pubDate><description><![CDATA[1.在applicationConext.xml 中配置事务注解驱动

&lt;!-- 事务注解驱动 --&gt; 
        &lt;tx:annotation-driven /&gt; 
         &lt;!-- 配置事务 --&gt;
       &lt;bean id="transactionManager" class="org.springframe...]]></description><category></category></item><item><title><![CDATA[mysql 8 修改root 密码]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773957</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773957</guid><author>bantaoti1130</author><pubDate>Tue, 07 Aug 2018 17:12:00 +0800</pubDate><description><![CDATA[主要参考：https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
需要注意的是创建文件的时候需要保存为 utf-8 无 BOM格式的不然容易报错。

C:\Users\esen&gt;mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 8.0...]]></description><category></category></item><item><title><![CDATA[ORACLE SQL 实现IRR的计算]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773952</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773952</guid><author>bantaoti1130</author><pubDate>Thu, 19 Jul 2018 10:59:00 +0800</pubDate><description><![CDATA[一、IRR计算的原理：
　　内部收益率（Internal Rate of Return (IRR)），就是资金流入现值总额与资金流出现值总额相等、净现值等于零时的折现率。
用公式 标识：-200+[30/(1+IRR)+30/(1+IRR)^2+....+30/(1+IRR)^10]=0。多次方程求解。
在计算机界求解高次方程的做法通常是利用牛顿插值法（Newton-Raphson...]]></description><category></category></item><item><title><![CDATA[db2 存储过程参数传递--字段类型转换产生的问题]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773769</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773769</guid><author>bantaoti1130</author><pubDate>Wed, 11 Jul 2018 16:00:00 +0800</pubDate><description><![CDATA[修改之前的脚本

select count(*)
from dbdk.dtdkg010 A
left join DBDK.DTDKG070 D ON D.PAY_NO = A.PAY_NO
LEFT JOIN CXLFM.DTFMA000_UNIT F ON F.DIV_NO = D.PLN_DIV1 AND F.DIV_NO2=D.PLN_DIV2
LEFT JOIN DB...]]></description><category></category></item><item><title><![CDATA[在oracle RAC 环境下用 PL/SQL Developer debug procedure 出现 hang 的情况]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773954</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773954</guid><author>bantaoti1130</author><pubDate>Fri, 16 Mar 2018 20:29:00 +0800</pubDate><description><![CDATA[现象描述：
　　用plsql developer 连接编译procedure 的时候都很正常。一旦开始Test进入Debug模式的时候就Hang住了。
初步猜测是没有权限，可是是DBA角色呀，如果没有权限会直接报没有权限的错误吧。
后面猜测是Oracle 或者PL SQL Developer的版本问题，用同一个PLSQL 在相同版本的不同机器上测试，结果另外一台机器可以Debug。...]]></description><category></category></item><item><title><![CDATA[oracle 11g 将非分区表转换为分区表在线重定义]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773949</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773949</guid><author>bantaoti1130</author><pubDate>Wed, 11 Oct 2017 19:11:00 +0800</pubDate><description><![CDATA[--操作的用户需要有以下的权限
GRANT CONNECT, RESOURCE TO CMIGDW;
GRANT EXECUTE ON DBMS_REDEFINITION TO CMIGDW;
GRANT ALTER ANY TABLE TO CMIGDW;
GRANT DROP ANY TABLE TO CMIGDW;
GRANT LOCK ANY TABLE TO CM...]]></description><category></category></item><item><title><![CDATA[Windows64bit-plsqldeveloper-install the easiest way]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773767</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773767</guid><author>bantaoti1130</author><pubDate>Tue, 11 Jul 2017 15:50:00 +0800</pubDate><description><![CDATA[The easiest way to add a 32 Bit Oracle Client:
1.Download the Oracle 11g or 12c Instant Client(http://www.oracle.com/technetwork/topics/winsoft-085727.html).2.Create an "InstantClient" subdirect...]]></description><category></category></item><item><title><![CDATA[Oracle SQL Tuning Advisor 测试]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773950</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773950</guid><author>bantaoti1130</author><pubDate>Sun, 02 Jul 2017 17:04:00 +0800</pubDate><description><![CDATA[如果面对一个需要优化的SQL语句，没有很好的想法，可以先试试Oracle的SQL Tuning Advisor。

SQL&gt; select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Da...]]></description><category></category></item><item><title><![CDATA[oracle 中的null与'']]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773947</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773947</guid><author>bantaoti1130</author><pubDate>Fri, 31 Mar 2017 11:39:00 +0800</pubDate><description><![CDATA[1.先看看Null与''在oracle中的表现

C:\Users\zen&gt;sqlplus hr/hr

SQL*Plus: Release 11.2.0.1.0 Production on Fri Mar 31 10:30:32 2017

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Con...]]></description><category></category></item><item><title><![CDATA[kettle5.4ODBC和OCI连接配置]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773948</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773948</guid><author>bantaoti1130</author><pubDate>Thu, 09 Feb 2017 22:07:00 +0800</pubDate><description><![CDATA[1.kettle 5.4 使用JDBC连接的时候报错(测试不同的数据库，发现只是连接11gRAC 的时候会报JDBC的错误)
具体报错如下

java.sql.SQLException: 建数据库连接出现异常:

oracle.jdbc.driver.OracleDriver

jdbc:oracle:thin:@90.12.xx.xx:1521:orcl

ORCL_...]]></description><category></category></item><item><title><![CDATA[记一次mysql数据恢复]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773945</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773945</guid><author>bantaoti1130</author><pubDate>Sat, 21 Jan 2017 15:50:00 +0800</pubDate><description><![CDATA[确切的说更像是一次数据迁移。
背景介绍：
 操作系统：Windows Server 2008 R2
 数据库版本：MySQL 5.5
 数据库的安装目录与数据文件目录不在同一个磁盘，数据文件所在的目录磁盘损坏。而后通过数据恢复工具恢复数据文件。前期研发的同事尝试启动恢复数据库，不成功，多轮尝试不成功后找到我。
1.得到同事给的数据...]]></description><category></category></item><item><title><![CDATA[Oracle SQL 劈开字符串]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773943</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773943</guid><author>bantaoti1130</author><pubDate>Thu, 29 Sep 2016 17:37:00 +0800</pubDate><description><![CDATA[一、数据样例

二、劈开单行

SELECT id_,REGEXP_SUBSTR(name_, '[^,]+', 1, rownum) h2
  FROM  (select id_,name_ from test_reg_count t
  where t.id_ =2 )
CONNECT BY level &lt;= length(name_)-length(replac...]]></description><category></category></item><item><title><![CDATA[Mysql备份--mysqldump&outfile]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773944</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773944</guid><author>bantaoti1130</author><pubDate>Tue, 20 Sep 2016 11:52:00 +0800</pubDate><description><![CDATA[1.备份工具mysqldump 客户端和服务器端都能用select outfile 只能写到服务器端
2.按表单位备份	　　a.单个表备份

mysqldump -uusername -p database table1 &gt;tableback.sql

mysql&gt; select * into outfile 'D:\someBookes\mysql\pracitc...]]></description><category></category></item><item><title><![CDATA[MySQL 5.7.11 重置root密码]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773941</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773941</guid><author>bantaoti1130</author><pubDate>Thu, 19 May 2016 15:12:00 +0800</pubDate><description><![CDATA[1.修改/etc/my.conf，添加参数skip-grant-tables
2.重启mysql
service mysqld stop
service mysqld start
3.用root 直接登录
[root@bogon ~]# mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \...]]></description><category></category></item><item><title><![CDATA[SQLserver Delete from where 与Oracle delete from where 的差异]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773942</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773942</guid><author>bantaoti1130</author><pubDate>Fri, 11 Mar 2016 16:00:00 +0800</pubDate><description><![CDATA[1.SQLserver 版本：
select @@version;
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 	Dec 28 2012 20:23:12 	Copyright (c) Microsoft Corporation	Enterprise Edition: Core-based Licensing (64-bit...]]></description><category></category></item><item><title><![CDATA[移植Oracle procedure 到 postgresql]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773940</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773940</guid><author>bantaoti1130</author><pubDate>Mon, 07 Mar 2016 11:56:00 +0800</pubDate><description><![CDATA[1.登录postgresql
psql -h 192.168.137.131 -p 5432 postgres satusc@6789#JKL
2.创建用户
CREATE USER name thunisoft createdb; --(equal CREATE ROLE name LOGIN createdb);
3.创建数据库create database test_data...]]></description><category></category></item><item><title><![CDATA[Oracle varchar2 4000]]></title><link>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773939</link><guid>https://blog.youkuaiyun.com/bantaoti1130/article/details/101773939</guid><author>bantaoti1130</author><pubDate>Tue, 23 Feb 2016 14:05:00 +0800</pubDate><description><![CDATA[关于oracle varchar2 官方文档的描述

VARCHAR2 Data Type

The VARCHAR2 data type specifies a variable-length character string. When you create a VARCHAR2 column, you supply the maximum number of bytes o...]]></description><category></category></item></channel></rss>