(Flavio Casetta) I was wondering why it’s not possible to reset a session modifiable parameter to its default value (that is the system wide current value), then just out of curiosity I tried to execute the following:

(John Hallas) A couple of years my team put together some procedures and the underlying databases to allow testing of as many RMAN recovery options as we could think of. We had two databases which gave us a Dataguard capability and we secured both databases using Commvault backups so we always had a

(stewashton) In 2014 I attacked the problem of “Overlapping ranges with priorities”. This time I’ll deal with NULLs and propose an improved solution.

(Frits Hoogland) Recently, Franck Pachot tweeted the following:

(Connor McDonald) One of the nice new things in 12c was the concept of identity columns. In terms of the functionality they provide (an automatic number default) it is really no different from anything we’ve had for years in the database via sequences, but native support for the declarative syntax m

(Mohamed Azar) After Clone or some unwanted situations, you may get the below issue when you’re trying to start the concurrent manager

(Fahd Mirza Chughtai) This is quick spit-out of commands, I used on my test virtual machine to install PostgreSQL 11 on Oracle Enterprise Linux 7.

(Andrejus Baranovskis) Machine Learning is all about data. The way how you transform and feed data into ML algorithm – greatly depends training success. I will give you an example based on date type data.

(Franck Pachot) Do you have tables with a column storing filenames? Long filenames with full path? If this is the case, then you probably realized how an index on this can be large.

(Martin Bach) At the time of writing Oracle’s Cloud Infrastructure as a Service (IaaS) offers 2 ways to connect block storage to virtual machines: paravirtualised and via iSCSI.