Category Archives: 其他技术

靠代码吃饭..

Luntbuild: config build schedule using Quartz 使用Quartz配置build安排

March 24, 2012 by Guoliang, 10 views

Quartz is a full-featured, open source job scheduling service that can be integrated with, or used along sidevirtually any Java EE or Java SE applicat

More…

Posted in 软件工程 | Tagged , , | Leave a comment

Using Date and Time in Ant 在Ant中使用日期及时间

March 22, 2012 by Guoliang, 12 views

Example:

<tstamp>            <format property="today" pattern="yyyy_MM_dd_HH_mm"/&gt

More…

Posted in 软件工程 | Tagged | Leave a comment

Oracle: 扩充TableSpace语句

November 13, 2011 by Guoliang, 11 views

Step1: check current status and get all file path
SELECT
B.FILE_NAME FILENAME,
B.TABLESPACE_NAME TABLESPACENAME,
B.BYTES/1024/1024 SIZE_MB,
(B.BYTES-S

More…

Posted in DB | Tagged , | Leave a comment

Oracle SQLs: Get system date; count user tables. etc,.

October 22, 2011 by Guoliang, 2 views

Get system date
select to_char(sysdate, ‘yyyy-mm-dd hh24:mi:ss’) from dual; — Get the formatted system date.
select sysdate from dual; — Get date
Co

More…

Posted in DB | Tagged , | Leave a comment

Oracle SQL Developper cannot show connections view/cannot create new connection

October 15, 2011 by Guoliang, 8 views

I installed Oracle 10g XE and SQL Developper 2 in my PC, they works perfect. Yesterday, I upgrade to 11g r2 XE, after restar my PC, the SQL Developper

More…

Posted in DB | Tagged | Leave a comment