(connormcdonald) Some people get very excited with roles, and quickly the number of roles proliferates to huge numbers…Until this happens

(Dbaharrison) So another week another characterset problem, this time it cleverly disguised itself to start with……

(Kris Rice) Another quick twitter inspired blog post inspired by the SQLcl account itself.

(Uwe Hesse) An existing RANGE partitioned table can easily be changed to be INTERVAL partitioned with the SET INTERVAL command. My table has been created initially like this:

(Martin Bach) Continuing the example of the previous blog post (is it possible to Smart Scan GTTs?), I am investigating if Smart Scans against GTTs can benefit from Flash Cache, or “optimised reads”. The easiest way to see this in your session is to calculate the change in session counters based on

(connormcdonald) If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications.

(Dbaharrison) So more on this cloud stuff then…..

(Scott Wesley) I’m a big fan of generating data with dual, using a perk of the connect by syntax.

(Ben) How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article.

(Andrejus Baranovskis) ADF 12.2.1.1 and 12.2.1.2 respectively comes with improvement for Masonry Layout component. Now we can define custom sizes for tiles – 9.4.1 How to Use a masonryLayout Component.