Fear No SQL
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…