- 博客(64)
- 收藏
- 关注
转载 The Secrets of Oracle Bitmap Indexes
Overview Oracle's two major index types are Bitmap indexes and B-Tree indexes. B-Tree indexes are the regular ...
2011-06-16 10:42:28 96
转载 Oracle 10g正则表达式
ORACLE终于在10G中提供了对正则表达式的支持,以前那些需要通过LIKE来进行的复杂的匹配就可以通过使用正则表达式更简单的实现。ORACLE中的支持正则表达式的函数主要有下面四个:1,REGEXP_LIKE :...
2011-06-14 15:12:06 81
转载 if-else-fi
[jerry@localhost bin]$ cat if-else.sh #!/bin/bashdirectory="./hard_one"if [ -d $directory ]; then echo "Directo...
2011-06-12 19:26:41 126
转载 #@ #$ #i
# "$#" number of args# "$@" all args [jerry@localhost bin]$ cat args_test.sh #!/bin/bashecho "This is all paramete...
2011-06-12 18:54:38 143
转载 Arrays
#!/bin/bashARRAY=('debian','ubuntu','fedora')ELEMENTS=${#ARRAY[@]}for ((i=0;iecho ${ARRAY[${i}]}don...
2011-06-12 18:48:56 58
转载 for loop
#!/bin/bashfor a in `seq 0 10`; doecho $adone[jerry@localhost bin]$ ./for_test.sh 0123456789101..10 ...
2011-06-12 18:42:45 74
转载 bash trap
#!/bin/bash# bash trap commandtrap bashtrap INT# bash clear screen commandclear;# bash trap function is executed w...
2011-06-12 18:38:03 116
转载 reading input to shell
!/bin/bashecho "Please type a word!"read wordecho "You just typed $word"echo "Please type two words!"read word1 wo...
2011-06-12 18:36:33 74
转载 xecuting shell commands with bash
#!/bin/bash# use backticks " ` ` " to execute shell commandecho `uname -o`# executing bash command without backtic...
2011-06-12 18:30:51 65
转载 global_variable VS local_variable &functional
#!/bin/bash#Define bash global variable#This variable is global and can be used anywhere in this bash scriptV...
2011-06-12 18:24:56 126
转载 Hello world
#!/bin/bash# declare STRING variableSTRING="Hello World"#print variable on a screenecho $STRINGNOTE: There is no s...
2011-06-12 18:22:03 68
转载 Global Temporary Tables
Global Temporary TablesApplications often use some form. of temporary data store for processes that are to compl...
2011-05-31 10:50:58 57
转载 informatica 安装
1.先搜个种子然后下载之。2.点server文件夹安装server3.点client文件夹安装client4.DB用户名一定要有creat session权限,可以用system5.添加souce时没有oracle要先...
2011-05-15 01:05:58 204
转载 dba_dependencies scripts
set lines 132select distinct owner, name, referenced_name from dba_dependencies where type in ('PACKA...
2011-04-27 09:22:31 79
转载 OLAP之全过程介绍(ETL过程)
经过多年来企业信息化建设,大部分都拥有了自己的财务,OA,CRM 等软件。这些系统都有自己的独立数据库,记录着企业运行情况某个方面的数据。但是单独看这些系统的报表,并不一定能对企业运行情况有全面客观的了解。就像只凭身高不能判断一...
2011-04-26 23:44:16 138
转载 ETL增量抽取方式
ETL增量抽取: 要实现增量抽取,关键是如何准确快速的捕获变化的数据。优秀的增量抽取机制要求ETL能够将业务系统中的变化数据按一定的频率准确地捕获到,同时不能对业务系统造成 太大的压力,影响现有业务。相对全量抽取而言,增量抽取的...
2011-04-26 23:00:25 104
转载 The Secrets of Oracle Bitmap Indexes
The Secrets of Oracle Bitmap Indexes Overview Oracle's two major index types are B...
2011-03-07 14:04:30 78
转载 Application Design Basics
Data Normalization: OLTP – 3NF DSS – 2NFData Type Selection: Choose Correct Data Types Right fro...
2011-03-01 11:10:28 69
转载 2NF and 3NF
2NF and 3NFThe 2NF and 3NF are very similar--the 2NF deals with composite primary keys and the 3NF deals with si...
2011-03-01 10:50:59 95
转载 ORACLE入门之OLTP和DSS不同数据库设计
* 在线事务处理(OLTP=Online transaction Processing )应用程序ex. 订票系统,生产系统* 决策支持系统(DSS=Decision Suport System )应用程序ex: 数据仓...
2011-03-01 10:44:34 309
转载 Oracle Concepts - pfile and spfile
Introducing the PFILE and SPFILEOracle provides two different types of mutually exclusive parameter files that y...
2011-02-23 10:42:26 78
转载 查询正常作为条件报错的问题
今天在论坛上看到一个有趣的问题:http://www.itpub.net/683461.html将函数调用放到SELECT列表中可以执行,如果放到WHERE条件中就会报错。查询正常作为条件报错的问题(续):http://...
2011-02-15 13:00:45 161
转载 Recipe 6.10. Creating a Delimited List from Table Rows
SELECT LPAD(' ', 1*level-1)||SYS_CONNECT_BY_PATH(ename, '/') "Path" FROM emp START WITH ename = 'SCOTT' CONNE...
2010-12-13 11:19:23 50
转载 Recipe 6.7. Extracting Initials from a Name
1. translate把要改的挑出2.replace掉You want convert a full name into initials. Consider the following name: Stewie G...
2010-12-09 14:08:17 49
转载 Recipe 6.1. Walking a String
Recipe 6.1. Walking a StringProblemYou want to traverse a string to return each charac...
2010-12-09 11:37:28 95
转载 Recipe 5.6. Using SQL to Generate SQL
select 'select count(*) from '||table_name||';' cnts from user_tables; CNTS -----------------------------------...
2010-12-07 14:35:54 63
转载 Recipe 5.2. Listing a Table's Columns
OracleQuery ALL_TAB_COLUMNS: 1 select column_name, data_type, column_id 2 from all_tab_columns 3 where ow...
2010-12-07 14:31:44 73
转载 Recipe 4.11. Merging Records
1 merge into emp_commission ec 2 using (select * from emp) emp 3 on (ec.empno=emp.empno) 4 when mat...
2010-12-07 14:28:12 67
转载 ORA-01779
Oracle中试图对一个子查询进行更新时可能会出现ORA-01779错误。该错误的内容为:ORA-01779: cannot modify a column which maps to a non-key-preserved t...
2010-12-07 14:18:14 53
转载 Recipe 4.10. Updating with Values from Another Table
Problem select * from new_sal DEPTNO SAL ------ ---------- 10 4000Column DEPTNO is the prim...
2010-12-07 14:01:31 83
转载 Recipe 4.7. Blocking Inserts to Certain Columns
ProblemYou wish to prevent users, or an errant software application, from inserting values into certain table co...
2010-12-07 11:12:16 54
转载 Recipe 3.1. Stacking One Rowset atop Another
ENAME_AND_DNAME DEPTNO --------------- ---------- CLARK 10 KING 10 M...
2010-12-06 14:45:03 66
转载 Recipe 1.10. Returning n Random Records
select * from ( select ename, job from emp order by dbms_random.value() ) wher...
2010-12-06 14:32:23 49
转载 Recipe 2.6. Sorting on a Data Dependent Key
select ename,sal,job,commfrom emporder by case when job = 'SALESMAN' then comm else sal end ...
2010-12-06 14:27:51 53
转载 Recipe 2.4. Sorting Mixed Alphanumeric Data
translate and replace 1.JPG2.JPG ...
2010-12-06 14:14:52 72
转载 1. simple search
1. simple search (only one table) Table 2-1. Search Condition Point Counts for OperatorsOpe...
2010-11-30 01:48:44 138
转载 where exists
Where exists (subquery)The WHERE EXISTS subquery is used when we want to display all rows where we have a matching...
2010-11-24 13:52:29 202
转载 动态表名
declare tablename1 number(3);STRSQL varchar2(30);TABLENAME2 varchar2(20);beginTABLENAME2 := 'dept';STRSQL :='SELEC...
2010-11-09 10:21:02 75
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人