Oracle APEX/REST

Version

To see the version from your browser use:

http://hostname:port/i/apex_version.txt

Runtime/Development

SELECT COUNT(*) 

FROM APEX_040200.WWV_FLOWS 

WHERE id = 4000;

Substitute APEX_040200 for the appropriate schema... e.g. APEX 4.1 uses APEX_040100, APEX 4.2 uses APEX_040200

If the query returns...

TODO: Conversion between Development and Runtime

Bibliography

https://matthiashoys.wordpress.com/2013/07/16/getting-apex-version-number-from-data-dictionary/ 
https://www.oracle.com/security-alerts/Critical Patch Update (CPU) Program Apr 2020 Patch Availability Document (PAD) (Doc ID 2633852.1)
http://dancingwithapex.blogspot.com/ http://www.grassroots-oracle.com/p/blog-reference-map.html
https://www.quickapeks.com/
Licensinghttps://blogs.oracle.com/database/post/apex-ords-futc
APEX Office Hourshttps://www.youtube.com/playlist?list=PL3S33P01ea05BSP-Gd6zHyNWiRby_oaOz
QuickSQLhttps://apex.oracle.com/pls/apex/f?p=8675309:LOGIN:::::: 
Best Practicehttps://community.oracle.com/thread/3671110?start=0&tstart=0 
Future Directionhttps://blogs.oracle.com/fusionmiddlewaresupport/future-direction-for-application-express-apex-and-the-oracle-http-server-ohs-modplsql-v2 
Reverse Proxyhttp://www.liberidu.com/blog/2009/06/15/apex-xdb-protocol-adapter-security-using-an-apache-reverse-proxy/ 
CDB vs PDBhttp://jastraub.blogspot.com/2017/02/convert-common-oracle-application.html https://www.oracle.com/database/technologies/appdev/apex/applicationexpress-database12c.html http://dgielis.blogspot.com/2015/01/preparing-architecture-for-apex-50.html 
Supporthttps://apex.world/ords/f?p=100
Output to docx, pptx, xlsx, pdf etchttps://explorer.co.uk/pl-pdf-or-aop-which-should-i-use/https://github.com/mt-ag/apex-excel-gatewayhttps://www.apexofficeprint.com/
CI/CDhttps://www.thatjeffsmith.com/archive/2021/04/ci-cd-with-oracle-database-and-apex/
AIhttps://content.dsp.co.uk/eye-on-oci/larry-ellisons-ocw2023-keynote-from-an-apex-point-of-view

orclapex