(connormcdonald) The long existing BITAND function is now within the documentation, to let you do logical AND on two numbers, and is also available from PL/SQL

(David Fitzjarrell) Security is on everyone’s mind, especially database administrators, and some DBMS vendors supply tools and/or settings, which allow the database to monitor and report possibly suspicious activity.

(Peter Manoharan) Recently one of our readers posted a question on a previous blog post on String types asking about how to create parameterised variable names. So we thought to write this blog post on that very subject.

(connormcdonald) I saw this on an ideas forum today

(tonyhasler) When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL).

(Prasanna Borse) Setting the scope for HDL is one the steps in preparing your Oracle Fusion HCM environment for data conversion or integration using HDL. In this article we will discuss available options and evaluate pros and cons for each.

(advait) This is a short article on RMAN where we can check if our backups are really intact and can help us in critical situation when we have to restore and recover the database.

(stewashton) The second solution for dividing a table into equal chunks does not do a JOIN. Instead it expands extent rows that contain several chunk boundaries, using an obscure method that I need to explain.

(connormcdonald) Most people already know about the very cool GATHER_PLAN_STATISTICS hint. If not, you can see an example here

(savvinov) In the previous parts (here and here) of the series we looked at some aspects of nested loop I/O optimizations, but we have left out the most important question (from the practical point of view): how these methods are doing time-wise?