APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Oracle SQL


Calculate minutes between two dates

Written by Richard Weug on Monday, 11 August 2014 23:20. Posted in Oracle SQL

Simple question but always a pain in the ass in finding the right solution:


Reset sequence values to align with table

Written by Richard Weug on Wednesday, 13 March 2013 16:35. Posted in Oracle SQL

Migrating data between environments sometimes requires the need to update the sequence next value. Here's a pice of code that might help when you need to alter certain sequence values.