SQL Pattern Matching Deep Dive - the PDF Version tháng 11 27, 2017 Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a d...
SQL Pattern Matching Deep Dive - the book tháng 11 07, 2017 Those of you with long memories might just be able to recall a whole series of posts I did on SQL pattern matching which were taken from a d...
#oow17 BDW Smartphone App Now Live tháng 9 27, 2017 It’s only 4 days and counting until OpenWorld 2017 starts. If you are coming to this year’s conference then you will definitely want to use ...
MATCH_RECOGNIZE and predicates - everything you need to know tháng 7 17, 2017 MATCH_RECOGNIZE and predicates At a recent user conference I had a question about when and how predicates are applied when using MATCH_RECO...
Big Data Warehousing Must See Guide for Oracle OpenWorld 2017 tháng 7 11, 2017 It’s here - at last! I have just pushed my usual must-see guide to the Apple iBooks Store. The free big data warehousing Must-See guide f...
Using Apache Zeppelin Notebooks with your Oracle Data Warehouse tháng 4 20, 2017 Over the past couple of weeks I have been looking at one of the Apache open source projects called Zeppelin . It’s a new style of applicatio...
It's out now - Database 12c Release 2 available for download tháng 3 02, 2017 Database 12c Release 2 available for download Yes, it’s the moment the world has been waiting for: the latest generation of the world’s most...
How to intelligently aggregate approximations tháng 1 24, 2017 The growth of low-cost storage platforms has allowed many companies to actively seeking out new external data sets and combine them with int...
Dealing with very very long string lists using Database 12.2 tháng 1 18, 2017 Oracle RDBMS 11gR2 introduced the LISTAGG function for working with string values. It can be used to aggregate values from groups of rows an...
MATCH_RECOGNIZE - What should I include in the MEASURES clause? tháng 1 16, 2017 Image courtesy of wikipedia This post is the result of reviewing a post on stackoverflow.com: http://stackoverflow.com/questions/41649178/ge...