<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[liupeipei1234的专栏]]></title><description><![CDATA[努力做自己想做的事情……………………]]></description><link>https://blog.youkuaiyun.com/liupeipei1234</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; liupeipei1234]]></copyright><item><title><![CDATA[oracle 误删、更新数据找回]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/126784983</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/126784983</guid><author>liupeipei1234</author><pubDate>Fri, 09 Sep 2022 16:12:38 +0800</pubDate><description><![CDATA[【代码】oracle 误删、更新数据找回。]]></description><category></category></item><item><title><![CDATA[oracle恢复被误编译覆盖的存储出过程]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/104037411</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/104037411</guid><author>liupeipei1234</author><pubDate>Sun, 19 Jan 2020 10:37:05 +0800</pubDate><description><![CDATA[方法一：

SELECT * FROM source$ AS OF TIMESTAMP TO_TIMESTAMP('2020-01-19 10:20:00', 'YYYY-MM-DD HH24:MI:SS')
where source like '%sp_copy_project%' order by line;

只查到一些简单的信息，不够恢复数据的。

上边的是原来那个，下边的是刚编译的。
...]]></description><category></category></item><item><title><![CDATA[oracle表空间扩容]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/96105348</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/96105348</guid><author>liupeipei1234</author><pubDate>Tue, 16 Jul 2019 09:57:59 +0800</pubDate><description><![CDATA[https://www.cnblogs.com/yx007/p/6651919.html
]]></description><category></category></item><item><title><![CDATA[Oracle 函数 Translate 的用法]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/87863275</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/87863275</guid><author>liupeipei1234</author><pubDate>Thu, 21 Feb 2019 16:18:52 +0800</pubDate><description><![CDATA[Oracle 函数 Translate 的用法

一、语法： 
TRANSLATE(string,from_str,to_str) 
二、目的 
返回将（所有出现的）from_str中的每个字符替换为to_str中的相应字符以后的string。TRANSLATE 是 REPLACE 所提供的功能的一个超集。如果 from_str 比 to_str 长，那么在 from_str 中而不在 to_st...]]></description><category></category></item><item><title><![CDATA[Oracle 11g中密码过期问题详解]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/83791466</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/83791466</guid><author>liupeipei1234</author><pubDate>Tue, 06 Nov 2018 17:56:46 +0800</pubDate><description><![CDATA[密码过期的原因一般有两种可能：

一、由于Oracle中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”所导致。

二、由于Oracle中默认在default概要文件中设置了“FAILED_LOGIN_ATTEMPTS=10次”，当输入密码错误次数达到设置值将导致此问题。

第一种情况解决方法如下：

1、查看用户用的哪种profile策略，一般是defaul...]]></description><category></category></item><item><title><![CDATA[easyui textbox 值改变事件]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/79666902</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/79666902</guid><author>liupeipei1234</author><pubDate>Fri, 23 Mar 2018 14:16:44 +0800</pubDate><description><![CDATA[&amp;lt;script type=&quot;text/javascript&quot;&amp;gt;
        $(function () {
            $('#A').textbox('setValue', 10);
            $('#C').textbox('setValue', $('#A').textbox('getValue'));
            function ch...]]></description><category></category></item><item><title><![CDATA[$.ajax()方法详解]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/79629333</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/79629333</guid><author>liupeipei1234</author><pubDate>Tue, 20 Mar 2018 17:54:54 +0800</pubDate><description><![CDATA[1.url: 要求为String类型的参数，（默认为当前页地址）发送请求的地址。2.type: 要求为String类型的参数，请求方式（post或get）默认为get。注意其他http请求方法，例如put和delete也可以使用，但仅部分浏览器支持。3.timeout: 要求为Number类型的参数，设置请求超时时间（毫秒）。此设置将覆盖$.ajaxSetup()方法的全局设置。4.async: ...]]></description><category></category></item><item><title><![CDATA[看下能否查到数据库是否有command未完成]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/16337825</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/16337825</guid><author>liupeipei1234</author><pubDate>Fri, 15 Nov 2013 11:23:42 +0800</pubDate><description><![CDATA[数据库未响应有可能处于恢复状态。
SELECT * FROM sys.dm_exec_requests 
看下能否查到数据库是否有command未完成。]]></description><category></category></item><item><title><![CDATA[程序员的薪资问题]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/12164367</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/12164367</guid><author>liupeipei1234</author><pubDate>Sun, 29 Sep 2013 15:13:43 +0800</pubDate><description><![CDATA[程序员的薪资问题]]></description><category></category></item><item><title><![CDATA[winform中的关机，重启实现代码]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10137361</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10137361</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 11:01:37 +0800</pubDate><description><![CDATA[首先在表示层添加Command.cs，Command里的代码如下：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;
using System.Drawing;
using System.]]></description><category></category></item><item><title><![CDATA[生成条形码的代码]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136997</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136997</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:54:55 +0800</pubDate><description><![CDATA[b/s:先添加引用BarcodeLib.dll，然后再后台写代码：
//生成条形码
               BarcodeLib.TYPE type = BarcodeLib.TYPE.UNSPECIFIED;
                type = BarcodeLib.TYPE.CODE93;
                try
                {]]></description><category></category></item><item><title><![CDATA[winform C# 控件随分辨率改变而改变]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136781</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136781</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:50:56 +0800</pubDate><description><![CDATA[public Form1()
        {
            InitializeComponent();
            int count = this.Controls.Count * 2+2;
            float[] factor = new float[count];
            int i = 0;
            f]]></description><category></category></item><item><title><![CDATA[在gridview根据不同的状态显示不同的颜色]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136589</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136589</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:46:48 +0800</pubDate><description><![CDATA[首先sql语句先这样写：
  SELECT *,case when Status='0' and UpTime>'" + DateTime.Now + "' then '未执勤' when Status='1' then '正在执勤' when Status='2'   then '已执勤' else '脱岗' end as state FROM 表名 ORDER BY ID desc

]]></description><category></category></item><item><title><![CDATA[asp.net中刷新自身的页面]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136431</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136431</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:45:10 +0800</pubDate><description><![CDATA[只需在里添加下面一句代码即可代码： 
   //htb.aspx是要实现刷新页面的名字]]></description><category></category></item><item><title><![CDATA[在sql语句里获取时间段的时差]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136175</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136175</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:41:40 +0800</pubDate><description><![CDATA[计算时间段的差值：

select datediff(minute,StartTime,EndTime) from 表名 //是EndTime减Starttime的时间段
//minute:分钟差,hour:小时差,second:秒钟差]]></description><category></category></item><item><title><![CDATA[asp.net中关闭模式窗口时又弹出一新的窗口]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136047</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10136047</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:36:31 +0800</pubDate><description><![CDATA[只需要在里添加下面一句代码即可：]]></description><category></category></item><item><title><![CDATA[asp.net中的乱码问题]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135909</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135909</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:33:55 +0800</pubDate><description><![CDATA[在js函数里的乱码：
   encodeUrl("url地址")；//编码
   decodeUrl("url地址")；//解码

在asp.net页面里的乱码：

   Server.urlEncode("url地址")；//编码
   Server.urlDecode("url地址")；//编码


如果还不能解决的话在web.config的里写：]]></description><category></category></item><item><title><![CDATA[获取datalist里lable里的值及点击datalist里的button按钮]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135785</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135785</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:30:51 +0800</pubDate><description><![CDATA[首先.aspx页面的datalist1里的代码：
 
 
    
      
        ' Visible="false">
        ' BackColor='<%# Eval("Status").ToString() == "在位" ? System.Drawing.Color.FromName("#009EEF") :          (Eval("Status]]></description><category></category></item><item><title><![CDATA[datalist的嵌套]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135565</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10135565</guid><author>liupeipei1234</author><pubDate>Wed, 21 Aug 2013 10:26:05 +0800</pubDate><description><![CDATA[datalist1嵌套datatlist2:
  在.aspx页面的代码：
    
      
        
            
              
               
                
                  ' Visible="false">
                  ']]></description><category></category></item><item><title><![CDATA[关于获取gridview里点击时获取对应的id号]]></title><link>https://blog.youkuaiyun.com/liupeipei1234/article/details/10108071</link><guid>https://blog.youkuaiyun.com/liupeipei1234/article/details/10108071</guid><author>liupeipei1234</author><pubDate>Tue, 20 Aug 2013 14:46:03 +0800</pubDate><description><![CDATA[首先在.aspx页面的gridview里写下

 
   ' />
 

然后再后台.cs的gridviewd的RowCommand事件里写下：
        //点击确认头像按钮
        protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
        {]]></description><category></category></item></channel></rss>