11 2011 档案

摘要: using RMDIR command in windows to remove non-empty folder阅读全文

摘要: A working example that bad SQL statement causes too much CPU usage.阅读全文

摘要: 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 阅读全文