Miscellaneous - To-do List

A collection of things that still need to be done, or that would be nice to have, on this site.

Do something nice with this, maybe on page 1067:

select s1.sid
,      s2.sid
from v$session s1
,    v$session s2
where s1.final_blocking_session = s2.sid

$(function(){
    $(document).on("cut copy paste","#P10_PAGE_ITEM",function(e) {
        e.preventDefault();
    });
});

Edition-Based Redefinition seems interesting: https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS020

Process Excel sheets directly instead of having to convert to CSV: https://blogs.oracle.com/apex/easy-xlsx-parser%3A-just-with-sql-and-plsql

Internet Explorer 11 by default switches to "compatibility view" (aka: IE7+ActiveX rendering) for sites it detects as behind the firewall (what it calls "intranet").
I noticed this when working on a development system behind the firewall; that setting really messes up the layout...

There is a simple fix to disable this "feature" - just add this to the <head> html tag (in Apex that would be in the Header section of the Page template): <meta http-equiv="X-UA-Compatible" content="IE=Edge">

More info: https://github.com/cockpit-project/cockpit/issues/9269

http://psoug.org/reference/instead_of_trigger.html
https://stackoverflow.com/questions/47441768/ora-01733-virtual-column-not-allowed-here-when-inserting-into-a-view
https://forum.foex.at/question/ora-22816-unsupported-feature-with-returning-clause

.t-Report-wrap, .t-Report-report {
  width: 100%;
}

https://tedstruik-oracle.nl/ords/f?p=25384:1065:::NO:RP::

http://apex-smb.blogspot.com/2011/12/apexapplicationstopapexengine.html
2. It looks like stop_apex_engine will roll back any SQL inserts/updates/deletes that occur in the routine, where as g_unrecoverable_error allow them to be committed.

Cursor c Is
    Select a.pk_id
        From a_table t
        Join a_view v On v.pk_id = t.pk_id.pk_id;

Gives “no connection to oracle” on database 12.2.0.1.0 and PL/SQl Developer 12.0.7. I cannot reproduce this on Database 18 XE and PL/SQL Developer 11.0.6.

APEX Project Eye
APEX Project Eye combines interactive, drill-down page summaries, graphical page flow diagrams, automatic documentation generation, database object dependency information, and session tracing, making it easy to see how an application is built, what it depends on, who is using it and how.

To-do List

Blocks

Copy/Paste Prevention

Edition-Based Redefinition

Easy XLSX Parser: Just with SQL and PL/SQL

IE 11 Compatibility View

Instead of triggers

classic report 100% width

redirect

Connection Lost

APEX Project Eye