ITPub博客

From : asktom http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1968769482859[@more@]It is because prior to 9i -- a stored procedure call would goto the database, run the procedure from start to finish and then return to the client. The client has no ability to get results from the stored procedure until its totally done. It is one message over, one message back. The stored procedure runs in the server, not on the client so the stored procedure cannot really do any I/O

From : http://www.itpub.net/viewthread.php?tid=1083104&page=1#pid12057097[@more@]关于取连续数据请教,谢谢!drop table test;create table test (id1 int,id2 int ,id3 int);insert into test (id1 ,id2,id3) values (1,45,89); insert into test (id1 ,id2,id3) values (2,45,89); insert into test (id1 ,id2,id3) values (3,45,89); insert into test (id1 ,id2,id3) values (8,45,89); insert into test (id1 ,id2,id3) values (12,45,89);insert into test (id1 ,id2,id3) values (36,45,89);insert into test (id1 ,id2,id3

by myself[@more@]test_orcl.batREM set oracle_sid=orclsqlplus /@orcl as sysdba @d:scripttest_orcl.sqlpuasetest_orcl.sqlcol host_name for a20select host_name,startup_time,status,database_status from v$instance;exit

From : metalink[@more@]Subject: HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node Doc ID: Note:415579.1Type: HOWTO Last Revision Date: 20-NOV-2007Status: MODERATEDIn this Document Goal SolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.0 to 10.2.0.0Information in this document app

From : metalink[@more@]Subject: How To Use Automatic Shared Memory Management (ASMM) In Oracle10g Doc ID: Note:295626.1Type: BULLETIN Last Revision Date: 10-SEP-2008Status: PUBLISHEDChecked for relevance on 28-8-2007. PURPOSEThe main goal of this document is to show you how to put in place the ASMM facility introduced with Oracle10g, how to configure it, and also some examples on how to monitor its activity.SCOPE & APPLICATIONAll the DBAs and users concerned with Database Administration acti

From : metalink[@more@]Subject: SKIP_UNUSABLE_INDEXES Initialization Parameter in Oracle Database 10g Doc ID: Note:281500.1Type: HOWTO Last Revision Date: 05-MAR-2008Status: PUBLISHEDIn this Document Goal Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: Information in this document applies to any platform.GoalThis article discusses about the initialization parameter SKIP_UNUSABLE_INDEXES in Oracle Database 10gSetting this parameter to TRUE disables error reporting

很好听的一首歌[@more@]当爱已成往事(女)往事不要再提 人生已多风雨 纵然记忆抹不去 爱与恨都还在心里 真的要断了过去 让明天好好继续 你就不要再苦苦追问我的消息 (男)爱情它是个难题 让人目眩神迷 忘了痛或许可以 忘了你却太不容易 你不曾真的离去 你始终在我心里 我对你仍有爱意 我对自己无能为力 因为我仍有梦 依然将你放在我心中 总是容易被往事打动 总是为了你心痛 (女)因为你岁月中 我无意的柔情万种 不要问我是否再相逢 不要问我是否言不由衷 女(男)为何你不懂 (别说我不懂) 只要有爱就有痛 (有爱就有痛) 有一天你会知道 人生没有

from : http://hi.baidu.com/coderui/blog/item/6faa40dded6a7fde8d1029d7.html通过这个方法解决.在此,表示感谢![@more@]///////////////////////////////////////////////////////////////////////////////////////////////文章名称：分析替换系统“rpcss.dll”文件的病毒(附修复方法)文章类型：病毒分析、系统修复编写作者：Coderui编写日期：2008年10月30日作者博客：http://hi.baidu.com/coderui///////////////////////////////////////////////////////////////////////////////////////////////英文名称：TrojanSpy.OnLineGames.iy

Love You Dad[@more@]While a man was polishing his new car, his 4 yr old son picked up Stone & scratched lines on the side of the car. 　　　　In anger, the man took the child's hand & hit it many times, not realizing he was using a wrench. 　　　　At the hospital, the child lost all his fingers due to multiple fractures. When the child saw his father.....with painful eyes he asked “Dad when will my fingers grow back' ？”　　　　The man was so hurt and speechless, he went back to his c

oracle schema : xdbFrom : http://www.oracle.com/technology/tech/xml/index.html[@more@]

from : http://v.youku.com/v_playlist/f269536o1p4.html[@more@]

From : http://bbs.auto.sina.com.cn/tableforum/App/view.php?bbsid=113&subid=1&tbid=712&fid=87145[@more@]继续努力,争取有一天,我也可以. 去欣赏 蓝蓝的天, 朵朵白云, 还有 清澈见底的水 . 心向往之Keep on doing. One Day , I will travel by car by myself.

好久都没有摸拍了, 刚开始都没有信心上去打. 同事打累了,只好上去顶一会, 打一会后,感觉还不错. 值得说明的是: 这是我第一次在上班时间,正大光明地在玩, 这就是外企的好处之一吧. 我想. 另外, 运动后 , 出出汗,感觉很好, 头脑也很轻松. 总之,感觉不错,身心得到了锻炼. I have a high moment . I am glad to work with our mates .[@more@]

From : http://mp3.iciba.com/viewarticle-96.shtml[@more@]英文歌词Dream, dream, dream, dream. Dream, dream, dream, dream. When I want you in my arms, when I want you and all your charms, whenever I want you, all I have to do is dream.Dream, dream, dream. When I feel blue in the night, and I need you to hold me tight, whenever I want you, all I have to do is dream.I can make you mine, taste your lips of wine anytime, night or day. Only trouble is, gee whiz, Im dreamin my life away.I need you so tha

From : http://www.regexlab.com/zh/encoding.htm[@more@]字符，字节和编码[原创文章，转载请保留或注明出处：http://www.regexlab.com/zh/encoding.htm]级别：中级摘要：本文介绍了字符与编码的发展过程，相关概念的正确理解。举例说明了一些实际应用中，编码的实现方法。然后，本文讲述了通常对字符与编码的几种误解，由于这些误解而导致乱码产生的原因，以及消除乱码的办法。本文的内容涵盖了“中文问题”，“乱码问题”。掌握编码问题的关键是正确地理解相关概念，编码所涉及的技术其实是很简单的。因此，阅读本文时需要慢读多想，多思

From : http://www.bestlifeonline.com/cms/publish/health-fitness/Pressure-Release_Valves.shtml?cm_mmc=MSN-_-The%2040%2040%20Diet-_-Article-_-Pressure%20Release%20Valves[@more@]Pressure-Release ValvesCompiled by the Best Life research editorsMar 24, 2008 - 2:15:43 PM Page: 1 2 3 4 30 ways to ease stress, lower blood pressure, and live longer1 Stop sneaking cigarettes. Quitting the butts was the number-one lifestyle change mentioned by every doctor and researcher interviewed for this story. But eve

今天参加公司的 Toastmasters ，看到别的同事英语口语都很不错，而自己的忒差了。 很受打击，努力学习。[@more@]My english is so poor.

From : http://www.ixdba.com/html/ycategory/that-is-life/[@more@]看到 pinner 在 Oracle 2008 OOW 拍的照片, 外国的景色还真是好!

From WEB[@more@]1 year=1*12 months1 day=24 hours=24*(1*60mins)=24*60*(1*60 seconds)1 week =7 days注意：黑色字体是 oracle 8i，9i都可以使用的函数，蓝色字体是 Oracle9i新增的部分。 请大家在使用时，注意版本限制。add_monthscurrent_datecurrent_timestampdatimezoneextract(datetime)last_daymonths_betweennew_timenext_dayroundSYSDATEsystimestampTO_DATEtrunc()1： Add_Months语法：Add_Months(d,n) 函数 -- n可正可负作用： Add_Months(d,n) 返回日期 D 加上n 月的日期Example:A：下个月的今天select add_months(sysdate,1

v_update_string := 'UPDATE tmp_cashflow set match_id = ' || v_match_id || ' where cashflow_id in (' || p_cashflow_string || ')'; [@more@]ORA-01795: maximum number of expressions in a list is 1000ORA-06512: at line 1ORA-06512: at "MOARUSR.P_EXCP", line 227ORA-06512: at "MOARUSR.P_FEED", line 1057ORA-01795: maximum number of expressions in a list is 1000ORA-06512: at line 1ORA-06512: at "MOARUSR.P_EXCP", line 227ORA-06512: at "MOARUSR.P_MATCH", line 1480ORA