This article will be discussing regular expression capabilities that have been incorporated into SQL. Previously, the LIKE operator could only be used for simple pattern matching of a string; however, new operators, such as REGEXP_LIKE, can be used to do powerful regular expression pattern matching.
This article will be discussing the Flashback Query feature of Oracle database. As the name suggests, this feature is about querying database at a previous point-in-time. We can provide a previous time while executing a query, and the database will show results that would have shown at that time.
The Oracle Database Resource Manager is a feature that provides granular control of database resources allocated to users, applications, and services. The Oracle Database Resource Manager enables you to manage multiple workloads that are contending for system and database resources.
Transaction Recovery is a feature of Oracle database that allows DBAs to recover from transactions which have undesirable effects. Sometimes it happens that a transaction performs an undesirable effect, and we determine later that this transaction should not have been committed. In this case, we do not want to perform database point-in-time recovery as the rest of database is working fine. We only have a problem with one transaction. Oracle allows us to provide approximate times of the problematic transaction and search the archived and online redo log files for transactions performed during said time. Then we can identify the transaction and roll it back. Transaction recovery is very easy to use from Oracle Enterprise Manager, but it requires some setup to perform before we can use it.
This article will be discussing a new feature of Oracle 12c Database, the pluggable database, which builds on the container database concepts, found here. We will be discussing why it is needed, what it solves, its benefits and some examples of it.