2011年11月28日
Windows bat RMDIR command
摘要： using RMDIR command in windows to remove non-empty folder 阅读全文
posted @ 2011-11-28 13:55 FangwenYu 阅读(2067) 评论(0) 推荐(0)
A working example of bad SQL statement causes too much CPU usage
摘要： A working example that bad SQL statement causes too much CPU usage. 阅读全文
posted @ 2011-11-28 13:47 FangwenYu 阅读(1263) 评论(0) 推荐(0)
PLSQL Naming Convention Checking
摘要： 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 阅读(558) 评论(0) 推荐(0)