- 博客(15)
- 收藏
- 关注
oracle disable/enable all constraints and triggers
disable script: DECLARE BEGIN FOR i IN (SELECT table_name, constraint_name --disable first the foreign key FROM user_constraints WHERE constraint_type ='R' AND status ...
2009-06-12 13:35:04 324
pspad regex replace search
Replace Examples: Date format change from dd.mm.yyyy to yyyy-mm-dd. This will turn the European date style 26.8.1994 or 26/8/1994 into 1994-8-26. Search: ([0-9]{1,2}).([0-9]{1,2}).([0-9...
2009-05-22 09:14:51 127
sql server disable all constraints and triggers
USE [database name] EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL" GO EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL" GO Reference: http://www.s...
2009-05-18 09:50:27 148
db2 modify column type
DB2 is so hard to use, also its documentation... Even such a simple operation, it takes me much time... Generally, char->varchar, smallint->integer, you can just modify the column through this...
2009-05-11 08:56:01 307
db2 snapshot
1. open cmd2. execute command "db2cmd"3. set trace on: db2 update monitor switches using statement on4. get snapshot: db2 get snapshot for dynamic sql on "database name" >> "d:\sql.txt"5....
2008-12-10 10:10:18 288
Head First Design Patterns 读书笔记
Decorator, don't alter interface, but add resposibility. Adapter, convert one interface to another. Facade, make interface simpler.
2008-08-18 09:33:07 164
如何做一个rich text editor之初想
比如做一个wiki需要用的rich text editor,拿confluence和FCEditor为样本,需要有的基本功能: undo redo find replace Insert table (Insert row, Delete row, Insert column, Delete column) Insert unordered list Insert ordered list Bo...
2008-07-28 08:18:47 99
JSF specification摘要
Specified that implementations running in a JSR-250 compliant container have their managed bean methods annotated with @PostConstruct be called after the object is instantiated, and after injection is...
2008-07-13 13:00:02 90
google code jam practice problems
Problem description can be found here. A. Alien Numbers Follow is the solution: public String getTargetNumber(String alienNumber,String srcLang,String targetLang) { String ret = ""; ...
2008-07-11 07:23:15 116
Solving topcoder srm407 with python
CorporationSalary You can find the problem description here. Because the problem is little simple, so here change "If an employee has any subordinates, then his salary is equal to the sum of the salar...
2008-07-04 17:01:57 140
list sort
Usage: list.sort([cmp[,key[,reverse]]]) how to use cmp parameter def my_cmp(x,y): if x<y: return -1 elif x==y: return 0 else: return 1 arr = [2,5,3,1,4] arr.sort(my_cmp)...
2008-07-04 15:03:04 75
看过的觉得还算可以的网络小说
全本的:裸兰善良的死神大唐行镖随波逐流之一代军师不死不灭佣兵天下正在更新的: 紫川 庆余年 师士传说异人傲世录神墓赫氏门徒
2008-06-26 08:51:08 180
JDBC调用oracle PLSQL(用jpublisher生成代码)
如果有一个TYPE: CREATE OR REPLACE type EMP_TYPE AS object ( id NUMBER , name VARCHAR2 , birthday DATE , sex CHAR (1) ); 有一个Pacakge: CREATE OR REPLACE PACKAGE EMP_...
2008-05-14 08:34:49 409
oracle text performance
oracle text的索引跟其它的基本索引不同,当执行dml操作时,数据库不会自动维护这些索引(不过会将这些dml操作记录在表CTX_USER_PENDING里),需要调用存储过程ctx_dll.sync_index来维护索引。 当执行ctx_dll.sync_index时,会先去CTX_USER_PENDING表里查看未索引的行,然后将其索引。ctx_dll.sync_index能够利用多c...
2008-03-17 13:12:28 122
oracle用plsql将sql查询的所有数据导出为xml
第一步需要先建一个oracle directory。 create directory TEMP_DIR as '/home/oracle/temp'; declare xml_str clob; xml_file Utl_File.file_type; offset NUMBER := 1...
2008-03-13 07:22:21 1109
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人