Fangwen.YU

摘要： CASE WHEN might lead to wrong outer join result in 11.2.0.2. This article gives an working example. 阅读全文

摘要： Notes on -- Chapter13: MySQL Server Status 阅读全文

摘要： Notes on -- Ch12: Security 阅读全文

摘要： Notes on -- Chapter11: Backup and Recovery 阅读全文

摘要： Notes on -- Chapter10: Application-Level Optimization 阅读全文

摘要： Notes on -- Chapter9: Scaling and High Availability 阅读全文

摘要： Notes on -- Chapter8: Replication 阅读全文

摘要： Notes on -- Chapter 7: Operating System and Hardware Optimization 阅读全文

摘要： Notes on -- Chapter 6: Optimizing Server Settings 阅读全文

摘要： Notes on -- Chapter 5: Advanced MySQL Feature 阅读全文

摘要： Notes on -- Chapter 4: Query Performance Optimization 阅读全文

摘要： Notes on - Chapter 3: Schema Optimization and Indexing 阅读全文

摘要： Notes on : Chapter 1 - MySQL Architecture 阅读全文

摘要： Quite preliminary, misc notes on MySQL 阅读全文

摘要： One interesting trick to spell the number using SQL! 阅读全文

摘要： You may wonder what the hell the difference between "DATA_OBJECT_ID" and "OBJECT_ID" sometimes. Congrats, you are not alone. Here we go -- 阅读全文

摘要： A simple example of Oracle Secure Application Role 阅读全文

摘要： Example of converting physical standby database to snapshot standby databsae 阅读全文

摘要： Oracle Data Guard - real time apply 阅读全文

摘要： A weird problem when loading LOB file using SQL*LODER 阅读全文

摘要： Set up physical standby db example 阅读全文

摘要： Implement "read lock" using Oracle VPD 阅读全文

摘要： Operator "OR" in SQL statement may lead to inefficient "correlated sub-query". Watch out! 阅读全文

摘要： Using UTL_FILE and DBMS_XSLPROCESSOR to write CLOB into files. 阅读全文

摘要： Library Cache Lock could be caused by connecting to database using wrong password. 阅读全文

摘要： Notes on the book -- Refactoring Database - Evolutionary Database Design 阅读全文

摘要： Some issues happened when installing MySQL on windows 阅读全文

摘要： Beginning with Oracle Database 11g Release 2 (11.2.0.2), you can create policies on applications that include MERGE INTO operations 阅读全文

摘要： Use DBMS_SQL with caution, it can not only lead to "memory leak" issue, but also cause security issue. 阅读全文

摘要： Oracle Character set – Everything a New oracle DBA needs to know 阅读全文

摘要： TTS is not designed to replace schema level exp/imp 阅读全文

摘要： The differences between the functions that return CLOB and VARCHAR2 used in SQL statement 阅读全文

摘要： Abuse of LOB in SQL is nightmare. This article gives out an example on the efficiency of LOB operation. 阅读全文

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

摘要： ORA-01795: maximum number of expressions in a list is 1000 阅读全文

摘要： A simple DBMS_LOB example 阅读全文

摘要： Using BAT for multi-thread/process processing 阅读全文

摘要： Use Java Compiler API for arithmetic expression calculation 阅读全文