In looking through my older posts, I realized that I wrote my first post, Guide for the Perplexed, six years ago yesterday. I don’t have as much time to write as much as did during the first couple of years of this blog; I generally write two posts per month now. Even so, I hope … Read more
When attempting to use the ODBC Data Source Administrator to test a connection to an Oracle Database from an Oracle client – one that did not have TNSPING installed – I got the above error: Unable to connectSQLState=S1000[Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA When searching this error, I found quite a few … Read more
I really like the LIKE operator! (See what I did there?) I use it on a daily basis. It does have one frustrating shortcoming, however. Unlike the IN operator (where a list is used for comparison), you can only compare one pattern with each LIKE statement. If you have only a few patterns, this isn’t … Read more