SQL–Only Counting Records Sufficiently Spaced apart using Analytics with Windowing Clause and Anti Join

Lucas Jellema March 3, 2021 SQL 3 Comments

A nice SQL challenge was presented to me by a colleague. The challenges basically consisted of this table. A table contains records that describe login events. Each record has …

[Continue Reading...]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (6)

Gert-Jan Paulissen February 26, 2021 DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development 1 Comment

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)”, I told you about Git, Subversion, Maven and Flyway. In …

[Continue Reading...]

How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (5)

Gert-Jan Paulissen February 26, 2021 DevOps, Agile Scrum, APEX, Architecture, Continuous Delivery, Database, Deployment, PL/SQL, Software Development No Comments

Last time in “How to build an Oracle Database application (that supports APEX, Java, React or any other front-end) (4)”, I told you about the Oracle SQL Developer Data Modeler. …

[Continue Reading...]