<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[liunx  oracle  ]]></title><description><![CDATA[　　　　　　　　　　　　 不积跬步何以至千里,不积小流何以成江河！]]></description><link>https://blog.youkuaiyun.com/stonewenxin</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; stonewenxin]]></copyright><item><title><![CDATA[oracle 管理入门笔记]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/4349788</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/4349788</guid><author>stonewenxin</author><pubDate>Wed, 15 Jul 2009 11:18:00 +0800</pubDate><description><![CDATA[一、修改sys密码:SQL>alter user sys identified by "key";    oracle 远程sqlplus 连接只能用 sys连接     sysdba  “sys”    sysoper  “public”二、windows 客户端和secureCRT SQLPLUS乱码问题;如数据库oracle server用的是al32utf8   1、windows客户]]></description><category></category></item><item><title><![CDATA[Centos5.3 oracle11g 安装笔记]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/4349729</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/4349729</guid><author>stonewenxin</author><pubDate>Wed, 15 Jul 2009 11:05:00 +0800</pubDate><description><![CDATA[vi /etc/sysctl.conf ：kernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 4194304net.core]]></description><category></category></item><item><title><![CDATA[ETL优化方案]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/4349661</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/4349661</guid><author>stonewenxin</author><pubDate>Wed, 15 Jul 2009 10:55:00 +0800</pubDate><description><![CDATA[1.引言 数据仓库建设中的ETL(Extract, Transform, Load)是数据抽取、转换和装载到模型的过程，整个过程基本是通过控制用SQL语句编写的存储过程和函数的方式来实现对数据的直接操作，SQL语句的效率将直接影响到数据仓库后台的性能。 目前，国内的大中型企业基本都具有四年以上计算机信息系统应用经验，积累了大量可分析的业务数据，这些信息系统中的数据需要通过搭建数据仓库平台才能得到科]]></description><category></category></item><item><title><![CDATA[redhat5.3 telnet open]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/4200711</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/4200711</guid><author>stonewenxin</author><pubDate>Tue, 19 May 2009 11:23:00 +0800</pubDate><description><![CDATA[linux开放telnet  安裝：1、安装telnet-server-0.17-25.i386.rpm[root @test /root]#  rpm -ivh telnet-server-0.17-25.i386.rpm 2、使用 vi 修改 /etc/xinetd.d/telnet ：[root @test /root]# vi /etc/xinetd.d/telnet# def]]></description><category></category></item><item><title><![CDATA[聚合 字符串连接]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/2667530</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/2667530</guid><author>stonewenxin</author><pubDate>Thu, 17 Jul 2008 17:06:00 +0800</pubDate><description><![CDATA[类似sum()函数,将聚合的值按照字符串连接方式连接起来.CREATE  FUNCTION [dbo].[strlink]( @fuji nvarchar(20))RETURNS nvarchar(100)ASbegin  DECLARE MyCURSOR CURSOR FOR SELECT distinct 国家 FROM dbo.SalesList where 区域]]></description><category></category></item><item><title><![CDATA[在dataset中添加新行]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1747500</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1747500</guid><author>stonewenxin</author><pubDate>Thu, 16 Aug 2007 23:52:00 +0800</pubDate><description><![CDATA[  SqlConnection SqlConn; DataSet objDataSet=new DataSet(); string Connstr=ConfigurationSettings.AppSettings["strConn"]; string SQLstr="select * from khxx"; SqlConn=new SqlConnection(Connstr)]]></description><category></category></item><item><title><![CDATA[vs2005制做左右上下移动的Listbox ( asp.net , C#)]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1593295</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1593295</guid><author>stonewenxin</author><pubDate>Mon, 30 Apr 2007 14:43:00 +0800</pubDate><description><![CDATA[ 制作可上下左右移动的 ListBox:方法:1.新建页面,拖放如下控件: 两个ListBox ,6个button,样式如下 各个button的功能>> 左移 右移↑上移↓下移C全部清空>> 代码如下:protected void Button1_Click(object sender, EventArgs e)    ...{        try        ...{        ]]></description><category></category></item><item><title><![CDATA[页面打印]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1571092</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1571092</guid><author>stonewenxin</author><pubDate>Thu, 19 Apr 2007 17:36:00 +0800</pubDate><description><![CDATA[     成绩单打印             .Noprint{display:none;}.PageNext{page-break-after: always;}                  　　　                                                                                                 ]]></description><category></category></item><item><title><![CDATA[Excel导入SQL数据库完整代码]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1571069</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1571069</guid><author>stonewenxin</author><pubDate>Thu, 19 Apr 2007 17:27:00 +0800</pubDate><description><![CDATA[protected void studentload_Click(object sender, EventArgs e)    {//批量添加学生信息        SqlConnection conn = DB.dataBaseConn();//链接数据库        conn.Open();         try         {            string fileurl = ]]></description><category></category></item><item><title><![CDATA[javascript小技巧 ]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1571039</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1571039</guid><author>stonewenxin</author><pubDate>Thu, 19 Apr 2007 17:05:00 +0800</pubDate><description><![CDATA[事件源对象 event.srcElement.tagName event.srcElement.type     捕获释放 event.srcElement.setCapture();  event.srcElement.releaseCapture();      事件按键 event.keyCode event.shiftKey event.altKey e]]></description><category></category></item><item><title><![CDATA[b/s中常用javaScript技术]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1570995</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1570995</guid><author>stonewenxin</author><pubDate>Thu, 19 Apr 2007 16:42:00 +0800</pubDate><description><![CDATA[b/s中常用javaScript技术在b/s开发中经常用到的javaScript技术  一、验证类 1、数字验证内   1.1 整数   1.2 大于0的整数 （用于传来的ID的验证)   1.3 负整数的验证   1.4 整数不能大于iMax   1.5 整数不能小于iMin 2、时间类   2.1 短时间，形如 (13:04:06)   2.2 短日期，形如 (2003-12-05) ]]></description><category></category></item><item><title><![CDATA[什么是ETL？]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1546068</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1546068</guid><author>stonewenxin</author><pubDate>Fri, 30 Mar 2007 09:05:00 +0800</pubDate><description><![CDATA[ETL即数据抽取（Extract）、转换（Transform）、装载（Load）的过程。它是构建数据仓库的重要环节。数据仓库是面向主题的、集成的、稳定的且随时间不断变化的数据集合，用以支持经营管理中的决策制定过程。数据仓库系统中有可能存在着大量的噪声数据,引起的主要原因有：滥用缩写词、惯用语、数据输入错误、重复记录、丢失值、拼写变化等。即便是一个设计和规划良好的数据库系统，如果其中存在着大量的噪声]]></description><category></category></item><item><title><![CDATA[SQL语句—嵌套查询 ]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1544782</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1544782</guid><author>stonewenxin</author><pubDate>Thu, 29 Mar 2007 09:06:00 +0800</pubDate><description><![CDATA[ 嵌套查询定义：1 .指在一个外层查询中包含有另一个内层查询。其中外层查询称为主查询，内层查询称为子查询。2 .SQL允许多层嵌套，由内而外地进行分析，子查询的结果作为主查询的查询条件3 .子查询中一般不使用order by子句，只能对最终查询结果进行排序子查询(sub query)where 表达式 [ not ] in (子查询)where 表达式 比较运算符 [ any|all ] 子查询w]]></description><category></category></item><item><title><![CDATA[水晶 报表插入值]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1543041</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1543041</guid><author>stonewenxin</author><pubDate>Tue, 27 Mar 2007 17:12:00 +0800</pubDate><description><![CDATA[ DataSet1 myset=new DataSet1();CrystalReport1 rpt1=new CrystalReport1();DataRow dr=myset.Tables[0].NewRow();dr[0]=10;dr[1]="60以下";myset.Tables[0].Rows.Add(dr);dr=myset.Tables[0].NewRow();dr[0]=15;dr]]></description><category></category></item><item><title><![CDATA[datagrid模板列动态链接]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1543038</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1543038</guid><author>stonewenxin</author><pubDate>Tue, 27 Mar 2007 17:09:00 +0800</pubDate><description><![CDATA[     >           ]]></description><category></category></item><item><title><![CDATA[合成数据项 sql查询]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1543035</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1543035</guid><author>stonewenxin</author><pubDate>Tue, 27 Mar 2007 17:08:00 +0800</pubDate><description><![CDATA[//合并字符串select Lastname+,+FirstNameAS EmployeesFROM EmployeesORDER BY LastName,FirstName ASC//对数字列进行运算select ROUND(UnitPrice*8,2)//数字列的乘法运算并取四舍五入的结果AS DiscountPrice From Productswhere ProdutID=]]></description><category></category></item><item><title><![CDATA[datagrid模板列弹出滚动新闻窗口]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1543028</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1543028</guid><author>stonewenxin</author><pubDate>Tue, 27 Mar 2007 17:03:00 +0800</pubDate><description><![CDATA[aspx前台：function showxw(xwlsh){var cq8=window.open("showxw.aspx?id="+xwlsh,"qc8","height=450, width=772,left=10,top=20,toolbar=no, menubar=no, scrollbars=yes, resizable=no, location=no, status=no");c]]></description><category></category></item><item><title><![CDATA[未将对象引用设置到对象的实例"异常的原因  ]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1542985</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1542985</guid><author>stonewenxin</author><pubDate>Tue, 27 Mar 2007 16:38:00 +0800</pubDate><description><![CDATA[未将对象引用设置到对象的实例"异常的原因   1、ViewState 对象为Null。2、DateSet 空。3、sql语句或Datebase的原因导致DataReader空。4、声明字符串变量时未赋空值就应用变量。5、未用new初始化对象。6、Session对象为空。7、对控件赋文本值时,值不存在8、使用Request.QueryString()时,所获取的对象不存在,或在值为空时未赋初始值9、]]></description><category></category></item><item><title><![CDATA[IE地址栏前换成自己的图标]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1537826</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1537826</guid><author>stonewenxin</author><pubDate>Thu, 22 Mar 2007 17:48:00 +0800</pubDate><description><![CDATA[IE地址栏前换成自己的图标 程序代码  可以在收藏夹中显示出你的图标 程序代码http://…/favicon.ico> ]]></description><category></category></item><item><title><![CDATA[十种珍惜的人 ]]></title><link>https://blog.youkuaiyun.com/stonewenxin/article/details/1537701</link><guid>https://blog.youkuaiyun.com/stonewenxin/article/details/1537701</guid><author>stonewenxin</author><pubDate>Thu, 22 Mar 2007 16:15:00 +0800</pubDate><description><![CDATA[十种珍惜的人   1.遇到你真正爱的人时─ 要努力争取和他相伴一生的机会。因为当他离去时，一切都来不及了。 2.遇到可相信的朋友时─ 要好好和他相处下去。因为在人的一生中，可遇到知己真的不易。 3.遇到人生中的贵人时─ 要记得好好感激，因为他是你人生的转折点。 4.遇到曾经爱过的人时─ 记得微笑向他感激，因为他是让你更懂爱的人。 5.遇到曾经恨过的人时─ 要微笑向他打招呼，因为他让]]></description><category></category></item></channel></rss>