Posts
All the articles I've posted.
Troubleshooting Duplicate Rows in Database Query Results
This article investigates duplicate results from multi-table left joins without discarding legitimately identical business records. It describes using Oracle ROWID for deduplication, assigning column aliases, and converting ROWID with ROWIDTOCHAR for Java object mapping.
Understanding Ajax’s async Option
This article investigates why an Ajax request returns data while the calling function returns undefined. It explains the order of callback assignment and function return in an asynchronous request, using a MiniUI example to illustrate the async setting.
Substring Searches over Large Datasets
A suggestion to use MySQL’s LOCATE function.
Handling Blank Rows When Importing Excel with Apache POI
This article explains how deleting an entire Excel row differs from clearing its contents when importing with Apache POI. It describes checking rows, cells, and cell types to exclude empty rows and prevent empty data from being written to the database.
Oracle Window Functions
A detailed introduction to Oracle window functions.
Problems Caused by Deleting Oracle Tablespace Files Directly
This article recounts troubleshooting ORA-01109 and ORA-12514 after deleting Oracle tablespace files directly. It records database startup, SYSDBA login, and listener configuration issues, and concludes that tablespaces should be removed through the normal deletion procedure.
Useful Blog Posts about Network Frames
These should be available in my bookmarks.
Getting Started with Redis (Part 1): Basic Setup on Windows
This article records basic Redis operations on Windows: connecting with redis-cli, setting requirepass and authenticating with AUTH, writing data with SET, and setting key expiration in seconds or milliseconds.