How to Resolve Garbled Data in PL/SQL Developer
Garbled Text We saw unreadable result in PL/SQL Developer after we INSERT INTO 3 rows and SELECT the table. We checked the language of this… Read More »How to Resolve Garbled Data in PL/SQL Developer
Multi-byte String
How to Resolve DataPatch Error at line 0: Could not open logfile
apply: WITH ERRORS When we are close to the end of datapatch, we saw an OS error: Error at line 0: Could not open logfile.… Read More »How to Resolve DataPatch Error at line 0: Could not open logfile
How to Count Occurrences of a String in MySQL
Since there's no function to count occurrences in strings, so I create a customized function to meet the requirement as followings:create function count_occurrences_case_sensitive(whole_string varchar(2048), match_string… Read More »How to Count Occurrences of a String in MySQL