11 2011 档案

摘要:using RMDIR command in windows to remove non-empty folder 阅读全文
posted @ 2011-11-28 13:55 FangwenYu 阅读(2067) 评论(0) 推荐(0)
摘要:A working example that bad SQL statement causes too much CPU usage. 阅读全文
posted @ 2011-11-28 13:47 FangwenYu 阅读(1261) 评论(0) 推荐(0)
摘要:Though we can set down some rules for the PL/SQL naming convention, it’s totally depending on developers’ morality to obey or ignore these rules. Fortunately, Oracle 11g introduces a new feature called “PL/SCOPE” which can be used for naming violation examination. By querying the Oracle view “USER_IDENTIFIERS”, you can know which variable in PL/SQL code violates the rules we have made. However, it’s not trivial to do this by simply querying this view, it’s good to have some utility wrapper for 阅读全文
posted @ 2011-11-28 13:38 FangwenYu 阅读(554) 评论(0) 推荐(0)