Display advanced Unicode in Oracle SQL Developer
It can be tricky sometimes to display Unicode characters in Oracle SQL Developer. For most Unicode characters, the UNISTR function will do the trick:...
Read MoreCreate test data for a database with foreign keys
There are various free data generators to create test or dummy data for a database, but generally speaking, they don’t handle foreign keys between tables very well. This video shows how to create random data from a free test data site, manipulate the tables in Excel to maintain foreign keys and other advanced referential integrity logic, and then convert the data to SQL insert statements.
Read MoreSending PHP mail from localhost
Here I provide instructions on sending PHP mail from localhost, that is, from a local development machine. I only tested this on Windows, but it should work with any...
Read MoreYahoo e-mail seems to be easily hacked
Yahoo e-mail accounts seem to be hacked more easily than any other e-mail service. For those who have Yahoo e-mail accounts, I recommend you switch to Gmail.
Read MoreHow to cite code borrowed from other sources
To cite code borrowed from other sources, the main concern in avoiding plagiarism is that you acknowledge that it is not your own work. Most fundamentally, you need to...
Read MoreWeb development resources and links
This page compiles various useful web development resources and links that I have used or come across and that I recommend. I add to it incrementally. Please suggest other useful resources in the comments below.
Read More