ITPub博客

前两天，有个叫‘慢慢’的网友在我的博客评论上推荐了一个网址，说那里有个治疗便秘的妙方，但不知是何原理，请我帮忙看一眼，详细解释一下。我赶紧过去寻宝，是一个叫天涯社区的网站，有个网名叫做‘熊熊和宝宝’的...

摘自：http://tkyte.blogspot.com/Suppose someone asks you:I need to take the results of a query and pivot a value. That is, I would like output from the EMP table to look like this: DEPTNO ENAMES------- ------------10 clark king miller20 adams ford ……can this be done in just SQL?With the addition of analytic functions in Oracle 8i Release 2 and the SYS_CONNECT_BY_PATH() function in Oracle 9i Release 1 – this became something we can in fact do rather easily in SQL. The approach we wi

今天看《oracle高效设计》中函数索引的内容，遇到一个简单的问题，如何使用这个索引：例子摘自《oracle高效设计》：create table project(project_ID number primary key,teamid number,job varchar2(100),status va...

摘自：http://tkyte.blogspot.com/Suppose someone asks you:I need to take the results of a query and pivot a value. That is, I would like output from the EMP table to look like this: DEPTNO ENAMES-----...

http://entropymine.com/jason/lr/lr2/lr2credits.html如图：http://lfree.itpub.net/get/4950/lr2credits1.gifhttp://lfree.itpub.net/get/4950/lr2credits.gif

http://entropymine.com/jason/lr/misc/lr2tech.txtTechnical info on Lode Runner 2by Stephen Appleby=================================================================The orignal plans for LR2 include...

http://entropymine.com/jason/lr/misc/lr2eastereggs.html At the main menu (Single Player/Multiplayer/Options/...), type:kratin'it: Plays a moviegoofy: Changes the picture for Wacky World in the Select ...

<F3>Go back one level<F4>Advance one level<ALT><F12>Gain five lives<ALT> 8Unlimited bombs<ALT> K"beach ball" power up<ALT> I "inviso" power up<ALT> T "morph" power up<ALT> B"cloak" power up <ALT><F7> ...

连接：http://entropymine.com/jason/lr/lr2/donuts/

LodeRunner2的Wacky Wall 11关 昨天终于过了Wacky Wall 11，实际上这一关很好过，自己一直没有找到诀窍。参考：http://www.aebc.com/~jcharvey/LR2/help/Wacky/Index.htm http://www.aebc.com/~j...

摘自oracle高效设计：create table t( a int, b int, c int, primary key (a,b))organization index;create index t_idx_c on t(c);set autotrace traceonly explainset autotrace traceonly explainselect a, b ...

最近作统计报表，使用toad发现一些问题，记录如下，toad的版本是7.6.0.11：select * from v$versionBANNER -------------------------------------------...

http://alexwu2300.blog.hexun.com/8360354_d.html曾经有几个常捐血的朋友来找我，他们平均在两三年内捐了十次以上的血。从外表看，几乎都出现肺虚的症状，皮肤偏黑而且干。他们有些是由于血浓度太低了，捐血站不再...

http://jinjiduli.blog.hexun.com/8329732_d.html网友‘海的女儿’，前几天在我的博客评论上，给大家带来了一件锻炼法宝，只是随着评论的覆盖，那宝贝也就被埋了起来，今天特用一篇文章来把它彰显出来。也不负这位网...

http://www.itpub.net/739188,1.htmlitpub有人遇到grep的问题，可能是字符集的问题。我的测试在rhel4上出现，其他版本没有遇到。# export LANG=zh_CN# grep '[A-Z]om' aaAnyway, Tom, I need your help. I'd like to...

在oracle的database目录存在一个hc_orcl.dat文件，orcl应该表示oracle_sid.google发现如下链接：http://forums.oracle.com/forums/thread.jspa?threadID=309881HC stands for a health check monitoring. It contain...

这个是我在comp.database.oracle.server新闻组问的问题，自己一直不知道为什么？昨天看了人家的解答，记录下来。http://jonathanlewis.wordpress.com/2007/03/12/methods/这个地址好像国内无法访问。March 12, 2007M...

1.man文档,例子： man cat | col -b > cat.txt2. info grub -s -o grub.txt

oracle 中按照正常的升序排序，null是在后面的，通过加入以上语句NULLS first可以改变排序，使NULL在前面。测试例子：SELECT * FROM (SELECT NULL a FROM DUAL UNION ALL ...

http://alexwu2300.blog.hexun.com/8129232_d.html去年夏天，一个年轻的女同事每天上午都不停的打喷嚏。我问她：『晚上是不是穿短裤睡觉？』她说：『你怎么知道？』我说：『看你天天上午喷嚏特别严重，猜出来的。』...