I’ve been posting some bits recently on some of the new Oracle Database 12.2 features, particularly analytic views. However as 12.2 on-premise is not yet released you needed a paid Oracle Cloud account to be able to do anything.
Recently however, Oracle Live SQL has been updated to version 12.2.
This means with a free Oracle account you can begin using and learning some of the new cool 12.2 features.