Posts

Showing posts from April, 2020

Practical Oracle SQL Webinar by ACE Director Kim Berg Hansan

Image
ACE Director Kim Berg Hansen is the author of the book "Practical Oracle SQL, Mastering the Full Power of Oracle Database". Kim Berg Hansen is known to present complicated SQL features in a very accessible way to developers so that they can apply these features in their daily work. In this webinar, Kim will present several SQL techniques,  taken from his new book Practical Oracle SQL , and show you how you can apply them in real life scenarios. Kim will cover the following topics: Tree Calculations with Recursion (Recursive subquery factoring) Functions Defined Within SQL (Functions in the WITH clause) Answering Top-N Questions (Analytic ranking functions) Rolling Sums to Forecast Reaching Minimums (Analytic window clause, recursive subquery factoring, model clause) Merging Date Ranges (Row pattern matching MATCH_RECOGNIZE) Click here to register for the webinar.

Oracle Database + Git = Gitora 4

Image
We are happy to announce the new version of Gitora, the version control tool for the Oracle Database. Gitora 4 enables you to manage your entire Oracle code base with Git. New features in Gitora 4 include: Push to and pull from repositories in GitHub, GitLab, Bitbucket etc... Simplified workflow and vastly improved working directory structure SQL Developer Extension (Coming soon.) Try Gitora today at:  http://www.gitora.com/