Fear No SQL
I have an Oracle Express Edition (XE) database running on almost every pc in my home. It’s not so numerous that I can’t manage them by manipulation of TNSNAMES.ORA; but I always thought it would be nice to manage them centrally via LDAP service name lookup. Unfortunately Oracle Internet Directory (OID) licensing is included with…
A not-uncommon request I hear is to explain when the contents of a view are updated. Sometimes this will be to explain the difference between a “view” and a “materialized view.” I like analogies as a tool to help describe what I’m trying to say. I wear glasses. Querying through a view is like looking…
One of the new features of 12c is the ability to create varchar2 columns up to 32k in size. This feature isn’t enabled by default. You have to put the db into upgrade mode, set max_string_size to EXTENDED and restart the db. However, once you do that, then the big strings are just like normal…
I’m disappointed with the container licensing. Seems odd to publish with a “consume more resources than needed” option turned on. Of course, people will want to buy the containers to take full advantage of their hardware. So I guess I can understand the sales model but from a branding perspective publishing with the brakes locked…
Looking forward to another great conference. I’ll presenting again this year, this time doing two sessions: What an Oracle Developer Ought to Know Why Developers Need to Think Like DBAs, Why DBAs Need to Think Like Developers
Oracle supports several methods for constructing Interval types including the NUMTODSINTERVAL and NUMTOYMINTERVAL functions. As their names imply, these simply convert a number of some units (day,hour,minute, second or month,year respectively) into an interval type. There is however no built-in method for reversing the process. The two functions below fill in this hole. I hope…
Last week was the 5 year anniversary of answering my first question on Experts Exchange and on Monday of this week I answered my 6000th question. With coincidental milestones like that it seems like a good time to reflect on what I’ve accomplished since I started participating. In that time I’ve also published 13 articles,…
First day was unintentionally APEX heavy for me. Not that that’s a bad thing, just sort of surprising to me in hindsight. Saw some really neat apps and ideas with HTML5 and dynamic actions. Also saw some new tools I’ll be checking out to make my own development more productive like aptana studio and apexlib.…
Just found this data yesterday, not sure when or how it got into the real table. Ironically the column that is corrupt is the mod_date which could have told me when. Note I can only display 2 digits of the year. If I try using yyyy format I’ll get an ORA-01877. I think it’s interesting…
Using the algorithm discovered by David Bailey, Peter Borwein, and Simon Plouffe, you can easily generate values of pi with a simple recursive query… SQL> SELECT d, to_char(bbp, rpad(‘0.’,55, ‘9’)) bbp, 2 TO_CHAR( 3 SUM(bbp) OVER (ORDER BY d), 4 ‘9.’ || RPAD(‘9’, d – 1, ‘9’) 5 ) pi …
According to recent press release http://www.oracle.com/us/corporate/press/1563775 Yes- you can install 11gR2 on Oracle’s latest release of Linux. However, I was not successful in my attempts. Upon further research it seems the certification of db and os is only for 11.2.0.3 which is only available through download from Oracle support. That’s fine for work where we…
I don’t normally write a lot of java stored procedures. They simply aren’t necessary most of the time; but today somebody asked me a question that just seemed a perfect fit. They wanted to know how to generate a SHA-256 hash for a given string. For most hashing tasks I’d recommend Oracle’s built-in package DBMS_CRYPTO;…
I’ve known about Heterogeneous Services and Gateways for a while but only recently got around to playing with them. Like others, I chose the ODBC Gateway because the database license includes the ODBC usage, unlike the rest of the Gateways that are each licensed separately. First, create an ODBC DSN for whatever database and platform…
Welcome to my blog about Oracle database development. I’m also interested in math and frequently write pl/sql and sql snippets to solve various math problems. For example, here’s an article I wrote about solving a combinatorics problem found in dart games like 301,501,701, etc. Fun with Oracle SQL – Solving Checkouts in a Game of…