摘要: using RMDIR command in windows to remove non-empty folder 阅读全文
posted @ 2011-11-28 13:55 FangwenYu 阅读(2039) 评论(0) 推荐(0) 编辑
摘要: A working example that bad SQL statement causes too much CPU usage. 阅读全文
posted @ 2011-11-28 13:47 FangwenYu 阅读(1249) 评论(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 阅读(536) 评论(0) 推荐(0) 编辑