- 博客(170)
- 收藏
- 关注
RSS订阅转载 Business Objects Query Builder – Part II
Hi All,This is the continuation of my previous blog related to Business Objects Query Builder.We are going to see ...
2013-06-17 13:09:26
231
转载 Oracle分区表
查看所有用户分区表及分区策略(1、2级分区表均包括)：select dbms_metadata.get_ddl('TABLE','T_WELCOME_CALL_LIST') fr...
2013-01-29 22:07:44
245
转载 PL/SQL development skill test
PL/SQL development skilltestName：比如如何进行异常处理？比如为什么用FORALL,比如如何用RECORD,COLLECTION,为什么？比如自治transactio...
2012-12-03 15:33:51
205
转载 数据库性能优化
转自：http://blog.tianshansoft.com/archives/439.html观看密码：tianshansoft这款工具的主要作用：数据库基本对象、性能优化(统计信息，索引碎片)、索引优化、异步数据...
2012-11-27 09:55:49
144
转载 good books
Linux Programming InterfaceHow Linux WorksJava for ProgrammersJava Power ToolsJava EE 6 with GlassFish 3 A...
2012-08-17 00:19:52
102
转载 ibm 摩根
title: Web Application Developer / IT Specialist / Industry Consultant - JavaSkill Requirements1) Technical Skills...
2012-08-16 13:35:59
131
转载 sql
SELECTc.CONTRACT_ID,c.CONTRACT_NBR,gc.GUARANTY_COMPANY_NAME AS gc,decode(c.BANK_CONTRACT_ID, 472, 'cfc', 'oth...
2012-08-08 18:00:56
129
转载 Oracle中sequence的使用方法
在Oracle数据库中，sequence等同于序列号，每次取的时候sequence会自动增加，一般会作用于需要按序列号排序的地方。 1、Create Sequence (注释：你需要有CREATE SEQUENCE或CREA...
2012-08-08 14:55:00
99
转载 Oracle Trunc函数
Trunc 函数 用法一： 为指定元素而截去的日期值。 语法如下： TRUNC(date,[fmt]) 参数分析： date 一个日期值。 fmt 日期格式，该日期将由指定的元素格式所截去。忽略它则由...
2012-08-08 09:45:44
169
转载 perl array
(RFC) Arrays: A Tutorial/ReferenceArray is a type of Perl variable.An array variable is an ordered collectio...
2012-07-16 14:01:44
147
转载 perl 第三章
写一个程序，将一些字符串（不同的行）读入一个列表中，逆向输出它。如果是从键盘输入的，那在Unix 系统中应当使用CTRL+D 表明end-of-file，在Windows 系统中使用CTRL+Z.$ cat 3.1#!/usr/...
2012-07-13 18:11:17
167
转载 Vi Editing Mode
What to TypeResultaappend after the cursoriinsert before the cursorIText inserted at beginning of lineAText insert...
2012-07-10 15:40:37
107
转载 grep 命令详解
用‘grep’搜索文本文件如果您要在几个文本文件中查找一字符串，可以使用‘grep’命令。‘grep’在文本中搜索指定的字符串。举个例子：假设您正在‘/usr/src/linux/Do...
2012-07-09 22:06:02
148
转载 shell-crontab
cron是一个UNIX工具,使用cron后台进程使得任务能够以后台方式在特定时间自动执行。这些任务通常叫做cron jobs. crontab是一个包括在特定时间要运行的cron记录的1.Crontab...
2012-07-09 11:11:39
121
转载 shell Permissions
This lesson will cover the followingcommands:chmod - modify file access rightssu - temporarily beco...
2012-07-07 10:13:21
107
转载 awk用法小结
1.awk简介awk是一种编程语言，用于在linux/unix下对文本和数据进行处理。数据可以来自标准输入、一个或多个文件，或其它命令的输出。它支持用户自定义函数和动态正则表达式等先进功能，是linux/unix下的一个强大编...
2012-07-06 18:31:36
109
转载 正则表达式Sed
绝对match查找 ： grep -w ab 2.txt 结果只有ab会打印出来sed -n '/\ba\b/p' 2.txt 结果只有a会打印出来 绝对匹配...
2012-07-06 16:33:08
112
转载 Morgan Stanley
df|grep run|awk '{print $5}'|sed 's/%//g' sed [options] 'command' file(s) sed [options] ...
2012-07-06 15:58:10
151
转载 常用查看Linux系统信息命令
系统# uname -a # 查看内核/操作系统/CPU信息# head -n 1 /etc/issue # 查看操作系统版本# cat /proc/cpuinfo ...
2012-07-05 17:20:16
72
转载 UNIX Quick Reference Sheet
control-zStop (don't kill) the foreground job, and then return to the shelljobsCheck the status of jobs in th...
2012-07-05 11:44:21
109
转载 SQL NULL
What is NULL?NULL represents theabsenceof a value.Technically it isnota value in itself. However we often us...
2012-07-05 11:19:46
141
转载 production support
Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE...
2012-07-05 08:45:23
149
转载 finacial knowledge
从最基本的securities学起。equity, bond, 它们的异同，关系，等等。。然后，再了解一下investment, risk, cash flow, libor, shibor, security...
2012-06-24 21:37:16
170
转载 递归打印数字
USE [Test]GO/****** Object: StoredProcedure [dbo].[sp_test] Script. Date: 06/20/2012 22:23:22 ******/SET ANSI_...
2012-06-20 22:26:39
113
转载 Top 10 Best Practices for Building a Large Scale Relational Data Warehouse
Contributors: Stuart Ozer, with Prem Mehra and Kevin Cox Technical Reviewers: Lubor Kollar, Thomas Kejser, Denny...
2012-06-16 22:45:59
191
转载 c# 螺旋矩阵
static void Main(string[] args) { int i, j; // int n=15; int n=9; ...
2012-06-15 23:13:42
350
转载 SSIS --Slowly Changing Dimension
Surrogate KeysAlso known as meaningless keys, substitute keys, non-natural keys, or artificial keys. A surrogate k...
2012-06-14 16:30:57
164
转载 工资比经理高且不是经理的员工
select a.*,b.* from T1 a, T1 b where a.id=b.manageridand a.salary < b.salaryand b.id not in (select managerid f...
2012-06-14 10:51:52
127
转载 BI Interview Questions
Recently I had to find a BI resource to do some ETL work for me. I wanted to make sure I had ...
2012-06-13 19:32:42
234
转载 id 连续,name 一样的, value 加和
create table etltable(name varchar(20) ,seq integer,money integer);create table etltarget (name varchar(20),min_s ...
2012-06-13 15:40:30
95
转载 SSIS Result Sets in the Execute SQL Task
The Execute SQL task supports the following types of result sets: The None result set is ...
2012-06-12 22:06:44
124
转载 SSIS display null in destination file
I suggest you can use string "Null" instead of "NULL" using Derived Column Transformation, and then load the dat...
2012-06-12 21:21:25
104
转载 ssis multiple table to one file
First, if the metadata is different. It does not work with union all . So,Why not just have 3 dataflow ta...
2012-06-12 18:45:39
78
转载 ssis export one table to multiple files
The following question was posed on theSSIS forumrecently:I have a table with 25 Million records. I want to tran...
2012-06-12 18:12:54
102
转载 Exporting data from multiple SQL tables to flat files using SSIS
SELECT nameFROM sysobjectsWHERE type = 'U'SELECT nameFROM sys.columnsWHERE (object_id = OBJE...
2012-06-08 15:36:39
125
转载 MS SQL Server查询优化方法
1. 如果是使用like进行查询的话，简单的使用index是不行的，但是全文索引，耗空间。 like 'a%' 使用索引 like '%a' 不使用索引用 like '%a%' 查询时，查询耗...
2012-05-31 16:41:41
77
转载 SAP的BI产品线一览（转）
一：SAP大会的主要内容(BI相关)：1.1：事件： 68亿美元收购BO大会有10%的讲座和实践课涉及BO，主题演讲的演示使用了BO的Xcelsuis，大会重要主题: BO与SAP的整合。1.2：配合：SAP与BO产品线互相促进...
2012-02-27 15:31:50
280
转载 Intermediate Crystal Reports XI Training
Intermediate Crystal Reports XI Training ObjectivesAll attendees will learn how to:Create and format multiple repo...
2012-02-27 11:02:26
129
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人