Fear No SQL
I tried the following query on 18c via Oracle’s LiveSQL site and the results don’t correspond to the documented functionality; or, at least, not my reading of the functionality. select to_utc_timestamp_tz(‘2018-04-27’) t from dual union all select to_utc_timestamp_tz(‘2018-04-27T17:40:25+00:00’) from dual union all select to_utc_timestamp_tz(‘2018-04-27T17:40:25Z’) from dual union all select to_utc_timestamp_tz(‘20180427T174025Z’) from dual union all select…
I presented this topic at the Collaborate 2018 conference. My slides can be found here. A couple of the slides included simplified queries so the text would fit on a single screen and remain legible. To find who is using temp, a more functionally robust query can be found here: /2018/03/08/who-is-using-temp-and-what-are-they-doing/ Similarly, the who is…
This is another article inspired by a recent request. That is, given a PDF file with tabular data, could I extract the data into a more human-usable format? Yes, it is possible but it requires multiple steps and does come with some caveats. The first step is converting the PDF into a format that is…
Recently I was asked to look at a problem where a simple query refused to use an index. The table had several million rows in it with a single index on one column populated with 3 values (in my sample the values are A, B, and C.) CREATE TABLE null_test ( col1 NUMBER, col2 NUMBER,…
Part 1Part 2 I’ve continued to enjoy this little puzzle and trying to find different ways of solving it. I’ve used the CONNECT BY clause to unpivot words into lists of letters but in this article I’ll show a more direct recursion on the word and then wrap up the series with the smallest and…
Part 1Part 3 In my last post I solved the task of finding words that can be typed with alternating hands by using collections, match recognize, and analytics. I closed with the comment that I was confident MODEL could be used to solve it too; but at the time I wasn’t sure how to do…