###### tags: `Oracle Apex` # Oracle Apex Resources ## Courses and Tutorials [Oracle APEX: Foundations (3 hours)](https://mylearn.oracle.com/learning-path/oracle-apex-foundations/112444) - 完成後可得到 Oracle Apex Fundation 證照徽章 ![](https://i.imgur.com/g3gPVy5.png) [Become an Oracle APEX Cloud Developer - New! 18+ Hours of expert training](https://mylearn.oracle.com/ou/learning-path/become-an-oracle-apex-cloud-developer-new/106577/) - [Oracle Apex 證照 1Z0-760](https://education.oracle.com/oracle-apex-cloud-developer-specialist/pexam_1Z0-760) [Oracle Apex 教學課程 ](https://apex.oracle.com/zh-tw/learn/tutorials/) [實際操作實驗室](https://apex.oracle.com/zh-tw/learn/tutorials/) - 瞭解利用 RESTful 服務建置 Oracle APEX App 是多麼簡單。 [Oracle Application Express - Curriculum, 2021/5/14](https://www.oracle.com/database/technologies/appdev/apex/apex-curriculum.html#) - 提供 study and activity guides. [Oracle APEX: From Idea to Application at the Speed of Light by Joel R. Kallman, 2020](https://www.youtube.com/watch?v=gHgaRBqiveA) <p style="text-align: right"> <iframe width="280" height="150" src="https://www.youtube.com/embed/gHgaRBqiveA" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> </p> <p></p> [Oracle Apex Hands-on Labs (18.1)](https://www.oracle.com/tools/technologies/handsonlab-apex.html) [Oracle Apex on GitHub](https://github.com/oracle/apex) - contains starter apps, sample apps, sample code, and plug-ins that you can use with Oracle APEX. ### QuickSQL :point_right: [使用 QuickSQL 快速建立 tables](https://hychen39.github.io/oracle_apex/2022/10/10/quicksql.html) [Oracle APEX Tutorial 8 - Quick SQL INSERT and Views](https://www.youtube.com/watch?v=aRJiuS6am50) ## Documents [Apex Resource shortcuts](https://apex.oracle.com/pls/apex/f?p=411:18) [App Builder User Guides](https://docs.oracle.com/en/database/oracle/apex/22.2/htmdb/quick-start.html#GUID-3D645140-7A61-4853-B975-218F3B99F687) [Apex JavaScript API Reference, R19](https://docs.oracle.com/en/database/oracle/application-express/19.2/aexjs/index.html) [Apex JavaScript API Reference, R22.2](https://docs.oracle.com/en/database/oracle/apex/22.2/aexjs/index.html) [Oracle Apex API Reference, R22.1](https://docs.oracle.com/en/database/oracle/apex/22.1/aeapi/toc.htm) [Oracle Apex API Reference, R19](https://docs.oracle.com/en/database/oracle/application-express/19.1/aeapi/index.html) [Oracle APEX Documentation R21, R22](https://docs.oracle.com/en/database/oracle/apex/index.html) [Ch13 Controlling Page Layout, App Builder User Guide 19.1](https://docs.oracle.com/en/database/oracle/application-express/19.1/htmdb/controlling-page-layout.html#GUID-2A096B0F-FAB4-4D9A-962B-3406A2F5CFBF) [3.8.1 About Referencing Session State, APEX Builder User's Guide 22.2](https://docs.oracle.com/en/database/oracle/apex/22.2/htmdb/managing-session-state-values.html#GUID-AC0C208D-61DF-40F6-8CC9-F3D59D24E5D0) [Icons in Universial Theme](https://apex.oracle.com/pls/apex/r/apex_pm/ut/icons) [10.5 Creating Help for Your Application, R21](https://docs.oracle.com/en/database/oracle/application-express/21.1/htmdb/creating-help-for-your-application.html) ## Architecture [Apex page processing flow](https://apex.oracle.com/architecture) ![](https://us.v-cdn.net/6032257/uploads/jive_attachments/3/2/3/32386854egami.png) ## Navigation and Search ### Navigation [Mega Menu, Apex 20.1](https://pitss.com/de/oracle-apex-20-1-new-features/) [Ch17.11 Creating Lists, App Builder User Guide 19.1](https://docs.oracle.com/en/database/oracle/application-express/19.1/htmdb/creating-lists.html) ### Search [Oracle Text](https://oracle-base.com/articles/9i/full-text-indexing-using-oracle-text-9i) - 對欄位做文字的搜尋。Oracle Text uses standard SQL to index, search, and analyze text and documents stored in the Oracle database, in files, and on the web. Oracle Text supports multiple languages and uses advanced relevance-ranking technology to improve search quality. - [Putting your text to work with Oracle Text](https://www.oracle.com/database/technologies/appdev/oracletext.html) ## Themes and Templates [Universal Theme](https://apex.oracle.com/pls/apex/r/apex_pm/ut/design-overview) - 提供 Universal Theme 下的各式 Componet 的 Overview ![](https://hackmd.io/_uploads/SJOr3V4n5.png) ### Template Options [Introduction to Template Options](https://www.youtube.com/watch?v=fslalBAdRzM) <iframe width="560" height="315" src="https://www.youtube.com/embed/fslalBAdRzM" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> ## Business flow Control ### Approval Components <iframe width="560" height="315" src="https://www.youtube.com/embed/pAG0b_5yeO8" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> [Introducing Approvals Component in Oracle APEX](https://blogs.oracle.com/apex/post/introducing-approvals-component-in-oracle-apex) ### Flow Engine Flows for APEX - Model & run process flows within APEX! <iframe width="560" height="315" src="https://www.youtube.com/embed/q77HqPuVN7s" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> ## Markdown support [Native Markdown Support in APEX 21.1](https://blogs.oracle.com/apex/post/native-markdown-support-in-apex-211) ## Files, Images, and BLOB Oracle APEX: How to add an Image as BLOB to Existing Table/Form/Report <iframe width="560" height="315" src="https://www.youtube.com/embed/f8hYQtAJ-WY" title="YouTube video player" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe> [9.9 Understanding BLOB Support in Forms and Reports](https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-blob-support-in-forms-and-reports.htm#HTMDB29659) [10.6.2 About Uploading and Downloading Files into a BLOB](https://docs.oracle.com/database/apex-18.1/HTMDB/understanding-blob-support-in-forms.htm#GUID-0197BAEA-6F98-4A52-B747-22BBFD3F9150) ## Cheat Sheet [Oracle Apex Cheat Sheet](https://tunahuntress.files.wordpress.com/2008/09/apex_cheatsheet_k08.pdf) [Interactive Grid Cheat Sheet, Github](https://github.com/mgoricki/orclapex-ig-cheat-sheet) [Oracle Apex Resources Cheat Sheet](https://www.insum.ca/oracle-apex-resources-cheat-sheet/) ## Plug-ins [APEX 21.1 Packaged Application Plugins](https://content.dsp.co.uk/apex/apex-21.1-packaged-application-plugins) [apex.world](https://apex.oracle.com/en/solutions/apps/#plug_ins) [Free APEX Plug-ins with Support | FOEX ](https://www.foex.at/fos/) [Commercial APEX Plug-ins | FOEX](https://www.foex.at/commercial-apex-plug-ins/) [Pretius plugins for Oracle APEX](https://apex.pretius.com/apex/f?p=105:1::::::) [Plug-ins-Pro](https://www.plug-ins-pro.com/ords/uc/r/plug-ins-pro/home) ### Maps [APEX Map Region vs. Google Map Plugin](https://jeffkemponoracle.com/2021/04/google-map-plugin-vs-oracle-apex-map-region/) ### Camara [APEX Camera Extension (ACE) Plugin](https://blogs.ontoorsolutions.com/post/apex-camera-extension/) ## Others ### Tree Region [Tree Search](https://apex.oracle.com/pls/apex/r/hari/demo_app/tree-search?session=16245014218790) 1. Enter any search term and hit Enter 2. Observe tree region refreshes and shows results as per the search term ### Links [Ontoor Solutions for apex: apex.confirm](https://blogs.ontoorsolutions.com/post/apex.confirm/) [Region Display Selectors](https://apex.oracle.com/pls/apex/apex_pm/r/ut/region-display-selector)