- 博客(29)
- 收藏
- 关注
原创 UPDATE tricks
UPDATE titles SET ytd_sales = t.ytd_sales + s.qty FROM titles t, sales s WHERE t.title_id = s.title_id AND s.ord_date = (SELECT MAX(sales.ord_date) FROM sales)The above sql works on sqlse
2005-07-21 21:05:00
622
原创 Java - Change System time automatically
1. Windows command "date" and "time" can change system time.2. Run OS command in java/** * Created by learner on 2005-06-07. */import java.io.IOException;import java.text.SimpleDateFormat;import java.
2005-06-08 13:56:00
910
原创 column types
Oracle:CHARVARCHAR2NCHARNVARCHAR2FLOATLONGNUMBERDATERAWLONG RAWBLOBCLOBNCLOBBFILEROWIDUROWIDXMLTYPEDB2:SMALLINT SMALLINT 两字节整数 -32768 to 32767INTEGER/INT INTEGER 四字节整数 -2147483648
2005-05-21 16:37:00
1001
原创 DATA IMPORT & EXPORT
Data Import & Export 1. MySQL data export:%MYSQL_HOME%/bin> mysqldump [options] database [tables] eg. mysqldump --opt database_name > backupfile.sql data import:There are two commands for importing
2005-05-07 22:14:00
1132
原创 DB Porting
从Oracle 到DB2 http://www-128.ibm.com/developerworks/cn/db2/library/techarticles/0209sunshulong/index1.html http://www-128.ibm.com/developerworks/cn/db2/library/techarticles/0209sunshulong/index2.html
2005-04-29 14:43:00
813
原创 DB2 Resource
IBM developerWorks 中国:DB2http://www-128.ibm.com/developerworks/cn/db2/newto/index.htmlhttp://www-128.ibm.com/developerworks/cn/db2/zones/basics/index.htmlCompiling DB2 UDB Stored Procedures with GCC o
2005-04-15 09:01:00
646
原创 Oracle Data Dictionary
1. Oracle 数据库管理脚本存放位置: Unix/Linux: %Oracle_home%/rdbms/admin Windows: %Oracle_home%/rdbms/admin2. Oracle 数据库管理脚本命名规则 cat*.sql 关于目录和数据字典信息 dbms*.sql 数据库中关于包的说明 prvt*.
2005-04-06 10:47:00
922
原创 Bulk SQL
Bulk SQL has the ability to process multiple rows of data in a single DML statement.It improves the performace by reducing the amount of context switching between SQL and host language.
2005-03-29 08:26:00
741
原创 How to connect to another database using sqlplus?
Assume you already logged into an oracle database, now you want to log into another database.The following are suggestion for you: - Connect to a local oracle database: Method: connect username/pass
2005-03-25 09:34:00
732
原创 Oracle resource
SQL*Plus Users Guide and Reference: http://rfhs8012.fh-regensburg.de/~oracle/sqlplus/toc.html Oracle Documentation: http://www.oracle.com/technology/documentation/index.html (cityforest/0411061
2005-03-19 09:10:00
788
原创 东北菜大集锦
1. 地三鲜土豆、茄子去皮(茄子嫩不用去皮)切滚刀块,土豆用慢火炸熟,茄子用油煸软,捞出来,留一点油,爆香葱、蒜,下青椒土豆茄子,加盐和一点鸡精,炒的时候淋一些水淀粉,出锅。2.乱炖把肉剪成片状,老公强调了一定要肥瘦都有,我就把肥瘦的分开,这样煮完的时候就可以把大肥肉片挑出来扔了。然后2个土豆削皮切块,白豆角摘段,一些松蘑泡开洗净,还泡了些东北的粉条。这样总计有5种东西煮在一起,应该算乱炖了吧?至
2005-03-15 08:21:00
907
原创 警示小故事(转)
John和Bill一起到山中探险,忽然他们发现一只老虎正深情的望着他们,John撒腿就要跑,Bill却迅速的从背包里拿出一双跑鞋穿在脚上,John看到后气急败坏的对说Bill“你穿什么鞋也跑不过老虎的”Bill同情的看了他一眼,回答说“我干吗要和老虎比,我只要跑过你就够了。”
2005-03-02 13:27:00
936
原创 电脑族美容新方案(转)
电脑对皮肤的三大致命伤害—— ●皮肤干燥有细纹、肤色变黄 ●长有斑点 ●眼部有细纹,黑眼圈严重。 美丽漂亮是每个女人的向往,但是对于经常坐在电脑前工作的女性朋友,你们 是否知道,长期在电脑前工作,会使皮肤出现以下3个问题———皮肤干燥有细纹 ,肤色变黄;长有斑点;眼部有细纹、黑眼圈严重。那么,如何对付电脑对我们皮 肤的伤害呢? 对付皮肤干燥 电脑的射
2005-03-01 17:33:00
1549
原创 食醋养颜(转)
食醋养颜 1、皮肤粗糙的人,将5份食醋与1份甘油混合调匀,涂抹于皮肤上,经常使用能使皮肤变得光洁、细腻。 2、将桃仁250克浸在500克食醋中,密封保存在玻璃瓶内,10天后即成。每日饮1汤匙,久之对改善皮肤粗糙、晦暗等有较好效果。 3、洗脸、洗手时加入1汤匙食醋,长期使用,可使皮肤变得光洁、细嫩。 4、取新黄豆250克,用醋浸泡15天,每天取10
2005-03-01 17:29:00
988
原创 How to debug Java Web Application?
http://ebxmlrr.sourceforge.net/3.0/developer/debugging.htmlFor instance, we use tomcat as web application server and Eclipse as IDE in windows, then we have to do the following things:1. Set environ
2005-02-24 16:09:00
935
原创 Heap size limitition in Java
If you get " Error occurred during initialization of VMCould not researve enough space for object heap", it is probably because there is not enough heap for you java application. You can try to use "J
2005-02-18 16:43:00
664
原创 LinkedHashMap and LinkedHashSet
维护插入顺序--使用新连接的HashMap和HashSet实现 http://www-900.ibm.com/developerWorks/cn/java/j-merlin/index4.shtml
2005-02-16 19:16:00
518
原创 Object Serialization
Java Serializationhttp://www.mactech.com/articles/mactech/Vol.14/14.04/JavaSerialization/ Java Object Serializationhttp://www.churchillobjects.com/c/11009.html Java Object Serialization Sp
2005-02-16 19:09:00
710
原创 利用ThreadLocal 提高可伸缩性
http://www-900.ibm.com/developerWorks/cn/java/j-threads/index3.shtml 轻松使用线程: 不共享有时是最好的 利用 ThreadLocal 提高可伸缩性
2005-02-01 14:13:00
534
原创 SoftReference、WeakReference 和 PhantomReference
http://www-900.ibm.com/developerWorks/cn/java/j-refs/index.shtml 学习如何有效地使用 SoftReference、WeakReference 和 PhantomReferencehttp://www.javaworld.com/javaworld/jw-01-2002/jw-0104-java101.html
2005-02-01 13:52:00
889
原创 Memory Leak
Considering the following scenarios: (1) Get java.lang.OutOfMemoryError. (2) A simple program eat up a lot of memory.These may hint you get memory leak problem. It usually happens durin
2005-02-01 09:44:00
586
原创 google 的21道面试问题
http://blog.csdn.net/whiteeagle/archive/2005/01/27/270970.aspx
2005-01-28 08:50:00
638
原创 system properties
In java program, system properties always includes values for the following keys: Key Description of Associated Value java.version Java Runtime Environment version java.vendor Jav
2005-01-27 15:40:00
510
原创 Create a string parser using java.util.StringTokenizer
一、概述 大多数Java程序员都曾经使用过java.util.StringTokenizer类。它是一个很方便的字符串分解器,主要用来根据分隔符把字符串分割成标记(Token),然后按照请求返回各个标记。这个过程称为Tokenization,实际上就是把字符序列转换成应用程序能够理解的多个标记。 虽然StringTokenizer用起来很方便,但它的功能却很有限。这个类只是简
2005-01-27 10:17:00
965
原创 Japanese meterals
流畅日本语http://www.liuchangjp.com/日本语世界http://www.rbysj.com/index.htm日本语天堂http://china-jp.net/
2005-01-21 19:24:00
918
原创 useful URL
1.http://www.scifish.com/~yuliya/doc/app/JBoss/JBoss-ch8.html JBoss 3.0.6 Step-by-Step Installation and Configuration Guide There is something not clear about:7.5.4 Enable JBoss CMP with MySQL,My Att
2004-11-27 12:56:00
976
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人