自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+

xiaotuni的专栏,每天进步一点点

互相学习,共同进步,https://github.com/xiaotuni

  • 博客(8)
  • 资源 (8)
  • 收藏
  • 关注

原创 oracle 月销售总金额的累加计算,实现 n = (n-1) + (n-2)

在Oracle 当中如要实现下面这种情况2 月分的销售总金额= 1 月分金额 + 2 月分的金额3 月分的销售总金额= 1 月分金额 + 2 月分的金额 + 3 月分的金额。...12 月分的销售总金额= 1 + 2 + ... 12 月分金额。现在在有一张表如数据如下图所示。现在用 下面代码实现当前月销售总金额累加的计算select y

2011-11-30 09:24:43 3337

原创 Solaris下交换分区的添加和取消

添加swap:1、成为超级用户    $su - root2、创建512m的swap文件   # mkfile 512m /export/home/swapfile/swapfile3、激活Swap文件   # /usr/sbin/swap -a /export/home/swapfile/swapfile4、验证swap文件   # /usr/sbin/swap

2011-11-29 09:35:04 1077

原创 oracle 表生成类的属性,插入、更新部分语句内容.

有的时候,经常要用到的表写一个对应的Model对象。如果一个表的字段非常多的话写起来很费时后来想到,所有的字段在数据库里都有数据库的类型也都可以找着于是就想到用sql的方法来生成model对象的属性 ;有了它就有可能进行增加、更新操作了。在增加、和更新的时候,字段多的话,经常有的时候,要么多写、要有少写于是想到数据库,用数据库生成这样的话,敢定不会少字段了同

2011-11-28 10:17:01 920

原创 在solaris下如何kill oracle所有进程

如果数据库的连接数太多访问起数据库来会非常的慢严重影响程序的效率在不想重新启动数据库实例的情况只可以杀死连接oracle的连接进程如下代码所示ps -ef | grep "ora" | grep -v grep | awk'{print $2}' | while read ORA_PIDdo kill -9 $ORA_PIDdone杀死进行只是暂时

2011-11-27 16:11:52 1504

原创 扩展方法 针对DataTable操作

扩展方法类,必须是静态的类,以及静态方法。public static class ExMethod{ /// /// /// /// /// /// /// public static List GetModelItem(this DataTable @dt, string split) where T

2011-11-25 13:55:17 2269

原创 反射 BindingFlags.IgnoreCase 的用法

反射属性名称,属性名称不区别大小写PropertyInfo pi = typeof(object).GetProperty("PropertyName", BindingFlags.IgnoreCase);这样是获取不出来的,得加上 BindingFlags.Public | BindingFlags.Instance 如下这样就可以了。PropertyInfo pi =

2011-11-24 17:13:04 2111

原创 Silverlight 获取Outlook下所有联系人帐号信息

要在输入发件人的时候,自动填充上来那这就要获取Outlook下所有联系信息来于是在网上找一个资料,不过都是C#写的现在改为有Silverlight获取联系人信息上面是我outlook里的写的几个联系人信息下面就是通过SL获取Outlook里的信息后显示出来的内容具体代码如下:private static dynamic outlook;

2011-11-03 17:58:34 1131

原创 Silverlight 调用outlook发邮件。

在开始Silverlight程序时有可能会用到发邮件于是就在想到调用outlook来进行发邮件由于从网上找些资料完成了现在调用发邮件基本没有问题了注意得引用一个dll【Microsoft.CSharp】,因为要用到 dynamic所以要引用 private static dynamic outlook; private static bo

2011-11-03 17:42:40 1355

DB2 Universal Database v8 Handbook

Publisher : Prentice Hall PTR Pub Date : August 04, 2003 ISBN : 0-13-066111-2 Pages : 496 IBM DB2 Universal Database V8 offers breakthrough availability, manageability, performance, and scalability. Now, straight from IBM, there's a start-to-finish guide to DB2 Universal Database V8 administration and development for UNIX, Linux, and Windows. This definitive reference covers every aspect of deploying and managing DB2 Universal Database V8, including database design for optimal performance, availability, and recoverability; day-to-day administration and backup; comparing, selecting, and using appropriate DB2 programming techniques; deploying networked and Internet-centered database applications; migrating to DB2 UDB from other databases or earlier versions of DB2; and much more. Using real-world examples, this book shows how to take full advantage of DB2 V8's most powerful enhancements. Philip K. Gunning brings together IBM's best tips and techniques for saving time and money in every facet of database design, development, deployment, and administration. Coverage includes: Leveraging DB2 V8's new Wizards, Advisors, and other automation/self-management features Using the enhanced DB2 XML Extender to build next-generation B2B applications Quickly creating Stored Procedures and UDFs with the new Development Center Exploiting multidimensional clustering, prefetching, materialized query tables, Java threading, and other performance improvements Using the DB2 improved monitoring and logging facilities Maximizing availability via online table and index reorganization and dynamic configuration Understanding the latest changes in the DB2 product family

2009-03-26

Oracle to DB2 UDB Conversion Guide

< Day Day Up > -------------------------------------------------------------------------------- Oracle to DB2 UDB Conversion Guide by Whei-Jen Chen et al. ISBN:0738499455 IBM Redbooks © 2003 (448 pages) This informative guide describes how to migrate the database system from Oracle to DB2 UDB Version 8.1 on AIX, Linux, and the Microsoft Windows platform. It presents the best practices in migration strategy and planning, migration tools, and more. Table of Contents Oracle to DB2 UDB Conversion Guide Notices Preface Chapter 1 - Introduction Chapter 2 - Oracle Migration Project Planning Chapter 3 - MTK Chapter 4 - Porting with MTK Chapter 5 - Conversion Reference Chapter 6 - Data Conversion Chapter 7 - Application Conversion Chapter 8 - Script Conversion Chapter 9 - Testing Appendix A - DB2 UDB Product Overview Appendix B - Data Types Appendix C - Oracle Call Interface (OCI) Mapping Appendix D - Converter for SQL*Loader Appendix E - Terminology Mapping Appendix F - Example Oracle Database Appendix G - Additional Material Related Publications Index List of Figures List of Tables List of Examples -------------------------------------------------------------------------------- < Day Day Up >

2009-03-26

PL/SQL Developer 7.0 User’s Guide

英文版<br>PL/SQL Developer is an Integrated Development Environment (IDE) for developing stored program<br>units in an Oracle Database. Using PL/SQL Developer you can conveniently create the server-part of<br>your client/server applications.

2007-09-12

Using NetBeansTM IDE 5.5

Your Guide to Getting Work Done in NetBeans IDE<br/>Welcome to the Using NetBeans™ IDE 5.5 guide. This guide is designed to give you<br/>a more detailed introduction to the IDE than is available in the Quick Start guide by<br/>exploring the main aspects of the IDE. This guide is geared mostly to newcomers to<br/>NetBeans IDE 5.5, whether you are new to using IDEs or an experienced IDE user<br/>that is switching over from a different development environment. However, readers<br/>of this guide are assumed to have at least a basic understanding of the Java<br/>programming language and related technologies.

2007-04-28

Microsoft.NET.框架程序设计,中文版

大家可以下载看看--李建忠译

2007-04-28

IBM Lotus Domino 7 邮件服务器配置全程攻略

IBM Lotus Domino 7 邮件服务器配置全程攻略

2007-04-05

MySQL/PHP Database Applications 英文版

MySQL/PHP Database Applications Welcome to the world of IDG Books Worldwide. IDG Books Worldwide, Inc., is a subsidiary of International Data Group, the world’s largest publisher of computer-related information and the leading global provider of information services on information technology. IDG was founded more than 30 years ago by Patrick J. McGovern and now employs more than 9,000 people worldwide. IDG publishes more than 290 computer publications in over 75 countries. More than 90 million people read one or more IDG publications each month. Launched in 1990, IDG Books Worldwide is today the #1 publisher of best-selling computer books in the United States. We are proud to have received eight awards from the Computer Press Association in recognition of editorial excellence and three from Computer Currents’ First Annual Readers’ Choice Awards. Our bestselling ...For Dummies® series has more than 50 million copies in print with translations in 31 languages. IDG Books Worldwide, through a joint venture with IDG’s Hi-Tech Beijing, became the first U.S. publisher to publish a computer book in the People’s Republic of China. In record time, IDG Books Worldwide has become the first choice for millions of readers around the world who want to learn how to better manage their businesses. Our mission is simple: Every one of our books is designed to bring extra value and skill-building instructions to the reader. Our books are written by experts who understand and care about our readers. The knowledge base of our editorial staff comes from years of experience in publishing, education, and journalism — experience we use to produce books to carry us into the new millennium. In short, we care about books, so we attract the best people. We devote special attention to details such as audience, interior design, use of icons, and illustrations. And because we use an efficient process of authoring, editing, and desktop publishing our books electronically, we can spend more time ensuring superior content and less time on the technicalities of making books. You can count on our commitment to deliver high-quality books at competitive prices on topics you want to read about. At IDG Books Worldwide, we continue in the IDG tradition of delivering quality for more than 30 years. You’ll find no better book on a subject than one from IDG Books Worldwide.

2007-04-05

Linux的高级路由和流量控制HOWTO中文版

这个文档依着对公众有利用价值的目的而发布,但不提供任何担保,即使是在经销或者使用在特定场合时的潜在担保。

2007-04-05

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除