Oracle APEX/REST
Minimum Version
Minimum Version
To avoid known security issues up to October 2021 the minimum version is:
21.1.0 with Bundle Patch 32598392
Version
Version
To see the version from your browser use:
http://hostname:port/i/apex_version.txt
Runtime/Development
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_040200If the query returns...
0 - This is a Runtime installation
1 - This is a Development installation
TODO: Conversion between Development and Runtime
Bibliography
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/
Runtime/Developmenthttps://docs.oracle.com/database/apex-5.1/HTMIG/converting-between-runtime-and-fulldevelopment-environments.htm
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
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/
Runtime/Developmenthttps://docs.oracle.com/database/apex-5.1/HTMIG/converting-between-runtime-and-fulldevelopment-environments.htm
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
apex.worldhttps://us13.campaign-archive.com/home/?u=167324a785cbc16fd0d857975&id=a5d24564aa (apex.world email archive)https://world.us13.list-manage.com/subscribe?u=167324a785cbc16fd0d857975&id=a5d24564aa (Mailing list signup)https://apex.world/ords/f?p=100:1:::NO:::