http://songhefei.itpub.net 人生若只如初见，何事秋风悲画扇？等闲变却故人心，却道故人心易变。骊山语罢清宵半，夜雨霖铃终不怨。何如薄幸锦衣儿，比翼连枝当日愿 .　 近日,一对夫妇----两个都是我的同学----的感情出现了裂痕,曾经花前月下、海誓山盟的两个人现在却已经走到了接近仇人的地步，如此下去恐怕连同学都做不成了。。。。。。　　那天翻到这页诗，读来更是让人伤感不已。不知道是当初两个人的选择出现了错误，还是选择本身没有错，而是因为两个人缺乏维持感情的信心。。。。。。　　难！　难！　难！ http://songhefei.itpub.net/post/7281/466239 Thu,10 07 2008 17:53:11 时间已进7月,又到了毕业的时候. 昨天,去农大跑步,看见一群一群的毕业生穿着学位服照相呢!我突然想起了<<草样年华>>中作者的感慨: 他们是一群蝌蚪,也许有人将来会变成青蛙;但是也有人会变成癞蛤蟆,不受人待见;更有甚者,有的人变成了牛蛙,一上岸就让人吃了! 他们呢?? http://songhefei.itpub.net/post/7281/465917 Mon,07 07 2008 11:44:17 create table stu (id number, stu studentobj);insert into stu values(1,studentobj(1,'Jack','Smith','aaaaaa',null));insert into stu values(2,studentobj(2,'mary','Smith','aaaaaa',null)); insert into stu values(2,studentobj(5,'mary','Smith','aaaaaa',null)); commit;select dbms_rowid.rowid_block_number(rowid) ,stu.* from stuselect * from dba_segments ds where ds.segment_name='STU'655 1 1 Jack Smith aaaaaa 655 2 2 mary Smith aaaaaa 655 2 5 mary Smith aaaaaa alter system dump datafile 12 block 655;*** 2... http://songhefei.itpub.net/post/7281/465022 Wed,25 06 2008 15:53:11 凌晨的点球对决,意大利出局! Piero 甚至都没有等到出场,悲乎?命乎? 23岁顶着R.Baggio 接班人的形象出山,虽然在俱乐部里风生水起,但是在国家队注定是一个不堪重用的阿斗. 98年世界杯,不在状态........ 2000年欧洲杯,决赛浪费两次单刀,成为意大利罪人! 2002年世界杯,进了一个无关同样的远射...... 2004年,仍然惨不忍睹 2006年,获得世界杯,单好象仍然与他无关 2008年.......没有登场,却已经闭幕.......... http://songhefei.itpub.net/post/7281/464897 Mon,23 06 2008 18:35:33 Timestamp with time zone是指当地时区与格林尼制时间的偏移。 SQL> create table t_timestamp(t1 date,t2 timestamp(9),t3 timestamp(9) with local time zone,t4 timestamp(9) with time zone) SQL> select dbtimezone from dual;DBTIMEZONE+08:00 SQL> select sessiontimezone from dual;SESSIONTIMEZONE+08:00SQL> insert into t_timestampvalues (to_date('2008-01-01 1:0:1','yyyy-mm-dd hh24:mi:ss'), timestamp'2008-01-01 1:0:1.000000001', timestamp'2008-01-01 1:0:1.000000001', timestamp'2008-01-01 1:0:1.000000001') 成功... http://songhefei.itpub.net/post/7281/464771 Sat,21 06 2008 11:53:37 山东作协副主席王兆山先生发表于齐鲁晚报的江城子: 天灾难避死何诉，主席唤，总理呼，党疼国爱，声声入废墟。十三亿人共一哭，纵做鬼，也幸福。银鹰战车救雏犊，左军叔，右警姑，民族大爱，亲历死也足。只盼坟前有屏幕，看奥运，共欢呼。 tmd太有才了 http://songhefei.itpub.net/post/7281/464717 Fri,20 06 2008 17:58:47 点儿背到家了!10分钟:里贝里受伤;30分钟: 阿比达尔制造了点球,并且被罚下70分钟: 亨利.......真是运气坏透了!还好,我是意大利的忠实拥趸.........感谢荷兰....... http://songhefei.itpub.net/post/7281/464603 Wed,18 06 2008 16:54:59 关于dual表的链接http://songhefei.itpub.net/post/7281/216328http://songhefei.itpub.net/post/7281/463102create materilized view 时报 ora-1422错误原来前两天测试dual表时候,insert 了一条数据,而没有删除select count(*) from dual;竟然返回了2真是让人苦笑不得查看create materialized view 的10046 trace file 其中有一段PARSING IN CURSOR #3 len=21 dep=0 uid=61 oct=3 lid=61 tim=2832974607 hv=2888538493 ad='66a7e540'select 'x' from dualEND OF STMTPARSE #3:c=0,e=545,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=28329745... http://songhefei.itpub.net/post/7281/464539 Tue,17 06 2008 11:40:05 Parallel recovery can speed up both instance recovery and media recovery. In parallel recovery, multiple parallel slave processes are used to perform recovery operations. The SMON background process reads the redo log files, and the parallel slave processes apply the changes to the datafiles. In a serial recovery scenario, the SMON background process both reads the redo log files and applies the changes to the datafiles. This may take a considerably long time when multiple datafiles need to be r... http://songhefei.itpub.net/post/7281/463506 Tue,03 06 2008 17:54:07 上一篇:http://songhefei.itpub.net/post/7281/216328SQL> desc dual;Name Type Nullable Default Comments ----- ----------- -------- ------- -------- DUMMY VARCHAR2(1) Y SQL> select dummy,dump(dummy) from dual;DUMMY DUMP(DUMMY)--------------------------------------------X Typ=1 Len=1: 88SQL> select dump('X') from dual;DUMP('X')----------------Typ=96 Len=1: 88 这里 Type 是不同的，也就是说Oracle 将dual 中的字段的类型是不同于一般的数据类型的SQL>select dbms_rowid.rowid_relative_fno(rowid),dbms_rowid.rowi... http://songhefei.itpub.net/post/7281/463102 Thu,29 05 2008 17:33:12