(Jeff Smith) In both v4.1.5 and v4.2, you can now select objects from your database tree, and drag them to another connection to have them copied.
Tag: Oracle
Next Step in Row generation in Oracle Database 12c SQL using JSON_TABLE
(Lucas Jellema) One of those things SQL developers are frequently looking at is the generation of rows: having a query return records that do not really exist. For example to generate test data or to produce records for all days in a month. Tom Kyte usually selects from data dictionary views.
Flashback Database Logs can exceed the Retention Target
(Hemant K Chitale) The documentation on the Flashback Retention Target in 11.2 and 12.1 states that this parameter specifies an upper limit on how far the database may be flashed back.
Video Tutorial: XPLAN_ASH Active Session History – Part 11
(Randolf Geist) The next part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.
Dynamic Flying Dashboard UI in ADF 12.2.1.1
(Andrejus Baranovskis) I took my old sample application implemented in 2010 – Dynamic Flying Dashboard UI Shell and upgraded it to recent ADF 12.2.1.1.
Statement-level PARALLEL Hint
(Christian Antognini) From version 11.2 onward, the PARALLEL hint supports two syntaxes: object-level and statement-level. The object-level syntax, which is the only one available up to version 11.1, overrides the DOP associated to a tables.
Oracle Text, Oracle R Enterprise and Oracle Data Mining – Part 4
(Brendan Tierney) This is the fourth blog post of a series on using Oracle Text, Oracle R Enterprise and Oracle Data Mining. Make sure to check out the previous blog posts as each one builds upon each other.
Stats Collection Time Anomaly
(Neil Chandler) Johnathan Lewis (@JLOracle) recently published a short post about Stats Collection Time, talking about the table dba_optstat_operation (and dba_optstat_operation_tasks ), which reminded me about (what I regard as) an anomaly in the output in the NOTES columns in Oracle 12C.
Undo and Redo
(Hemant K Chitale) Undo is where Oracle logs how to reverse a transaction (one or more DMLs in a transaction)
Oracle DECOMPOSE Function with Examples
(Ben) The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article.
