When I was at OOW this year I saw the new (?) Oracle Live SQL web environment in action during the Oracle JSON Hands-on Lab workshops. I had a go at it and I liked it very much. As far as I know they will/might introduce it on the internet as well for, for example, Oracle By Example (OBE) environments and test it yourself courses / workshops.
To give you the scoop, here are some screen shots. Hope you like them as much as I do (like the KISS look-and-feel).
HTH/M
livesql.oracle.com is available now, and has been for nearly a year I think
Yeah, probably even longer, I think. I added some XML DB examples to the public code library in 2015 (https://livesql.oracle.com/apex/livesql/file/content_CDGUJ1TNVJ6SKLQ94JU7U04FP.html), but I have never noticed that they also might rollout new functionality via Oracle By Example(OBE) training sections.
Up till now it was only small “code snippet” stuff.