用行动改变世界，做个有情怀的技术宅

以下是截止至 2021.02.28收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• CapsLock(On/Off) Indicator with Javascript in Oracle APEX 2021.02
• What is Collapsible Template in Oracle APEX - JavaInhand Tutorial 2021.02
• Add Logo Image to Oracle APEX Login Region 2021.02
• Add Background Image to Page in Oracle APEX 2021.02
• The Best Rich Text / HTML Editor for Oracle APEX 2021.02
• MLE and the Future of Server-Side Programming in Oracle APEX 2021.02
• Top 10 Reasons why Oracle APEX is Ideal for Oracle Forms Developers 2021.02
• On-premises APEX installations in Oracle Database 21c and beyond 2021.02
• Stop using validations for checking constraints 2021.02

以下是截止至 2021.01.30收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• My spin on the new Oracle APEX Application Development Service 2021.01
• Setup and configure the APEX Application Development Service (including email) in the Oracle Cloud 2021.01
• Add checkbox item to IR and Maintaining checkboxes state 2021.01
• Handling JavaScript Errors - Part 2 2021.01
• Handling JavaScript Errors - Part 1 2021.01
• Import an existing database and APEX app into the Oracle APEX Application Development Service 2021.01
• Add details section to IG 2021.01
• Pinch and Zoom like Instagram 2021.01
• Fetch API for Oracle APEX - Part 3: Security SIMPLIFIED 2021.01
• Fetch API for Oracle APEX - Part 2: Securing Endpoints 2021.01
• Fetch API for Oracle APEX - Part 1: Basic Usage 2021.01
• Rich animations for your APEX app 2021.01
• ReportMap Release 1.5 2021.01
• How to Quickly Build Templates in APEX Office Print 2021.01
• Creating a dynamic Organisation Chart in APEX in under an hour from your Active Directory 2021.01
• Cards – New Region Type in APEX 20.2 2021.01

本文是关于 Oracle Cloud 的一篇译文，也是 Oracle Cloud 系列文章第四篇，Oracle Cloud系列文章列表如下：

• Oracle Cloud 系列文章01：创建VM云实例
• Oracle Cloud 系列文章02：创建Oracle云数据库（自治事务处理ATP）
• Oracle Cloud 系列文章03：安装配置Oracle Cloud命令行接口工具（CLI）
• Oracle Cloud 系列文章04：在 Oracle Cloud (OCI) 中快速构建APEX应用程序

英文原文请查阅这里：https://blogs.oracle.com/developers/build-apps-fast-with-new-apex-service

今天，2021年1月13日，Oracle公司推出了一项新的 Oracle Application Express（APEX）服务，用于在Oracle Cloud中快速构建和部署现代化的数据驱动的应用程序。这项新服务是在 Oracle Cloud Infrastructure（OCI） 上使用 Oracle APEX 低代码应用程序开发的理想入口。它提供了一个简单的、易于使用且易于访问的平台，从而使创建功能强大的应用程序变得异常快捷。

关于Oracle APEX和低代码开发

Oracle APEX 从根本上简化了数据驱动的应用程序的开发和部署过程，使普通用户和专业开发人员都能够以比编码快38倍的速度创建Web应用程序。全球数以千计的 Oracle 客户正利用 Oracle APEX 来构建定制的应用程序，诸如：企业级报表系统、替换Excel等。它在全球拥有约50万个开发人员、倡导者及合作伙伴，目前每天有数百万的最终用户在使用用 Oracle APEX 创建的实时应用程序。Oracle 公司最近利用 Oracle APEX 为美国的患者和医护人员快速创建了 COVID-19 大流行应对应用程序，并支持三个非洲国家的国家疾病疫苗接种计划。

以下是截止至 2020.12.31收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• Oracle APEX 2019 Year in Review 2020.12
• A closer look at the Rich Text Editor of #orclAPEX 20.2 2020.12
• How to dynamically compute Interactive Grid Columns in #orclAPEX 20.2 2020.12
• Alert Region dynamically with Classic Report 2020.12
• Column “Read-only” Function (Interactive Grid #7) 2020.12
• AJAX Callback within Oracle APEX 2020.12
• Web Components in Oracle APEX 2020.12
• APEX 20.2 Hidden Gems 2020.12
• Part One: Low Code – Microsoft and Oracle 2020.12
• Faceted Search of Oracle APEX 2020.12
• Conditional Error Button On IG In Oracle APEX 2020.12
• Conditionally Change Select List Color In Oracle APEX 2020.12

以下是截止至 2020.11.29收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• New version of Quick PL/SQL, a code generator for PL/SQL 2020.11
• APEX Template Directives 2020.11
• APEX Fancy Facets 2020.11
• Displaying Master data in Detail IG Header 2020.11
• APEX Authentication Using Microsoft Azure Face API 2020.11
• Manage APEX users from your app 2020.11
• Dynamic Action to Disable Objects 2020.11
• Dynamic Action Set Focus Example 2020.11
• Dynamic Action Set Value Example 2020.11
• Dynamic Action Execute JavaScript Code 2020.11
• APEX 20.2 Report Printing - Use Oracle Analytics Cloud as a Print Server 2020.11
• 2020.11
• Oracle APEX 20.2: APEX Office Print (AOP) vs native PDF, Excel and HTML 2020.11
• A review of Azure DevOps Boards, from an APEX development perspective 2020.11
• APEX Native Mega Menu 2020.11
• Running Customer Managed ORDS on Autonomous Database? Here’s how to get ready for APEX 20.2 Upgrade 2020.11
• Column groups heading and styling (Interactive Grid #6) 2020.11
• Oracle APEX Displaying Help Text 2020.11
• Create, Read, Fill and Flatten PDF Forms with APEX Office Print 20.3 2020.11
• My steps to upgrade to Oracle APEX 20.2, ORDS 20.3 and AOP 20.3 2020.11
• Automate your business process in Oracle APEX 20.2 2020.11
• Running 360 Esports Reviews Using APEX - Part 2 2011.10

以下是截止至 2020.10.29收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• Show or Hide DOM Elements Using JavaScript 2020.10
• Making Interactive Grid Rows Editable on Condition in Oracle Apex 2020.10
• Synchronize Data from REST Services to Local Table. With no code at all 2020.10
• A Simple Guide to the New Cards Region in APEX 20.2 2020.10
• Faceted Search Enhancements in APEX 20.2 2020.10
• APEX 20.2 New Reporting Features 2020.10
• Integrating APEX with Office 365 via Microsoft Graph REST API 2020.10
• 10 Things I Wish I Knew When I Started Using APEX 2020.10
• Generating ZIP files in Oracle APEX 2020.10
• Dynamic LOV With A Subquery In Oracle APEX 2020.10
• Oracle APEX JS Confirm And PL/SQL Dynamic Action 2020.10
• Launching apexpert.in - Integrated solutions using Oracle APEX and Native Mobile App 2020.10
• How do I edit region attributes in APEX 20.2? 2020.10
• Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app 2020.10
• Build Configurable Help Option – Easy, Fast and Low Code 2020.10
• Format dates using APEX_UTIL.GET_SINCE 2020.10
• Telegram Integration in your APEX application 2020.10
• Use JavaScript API to work with cookies in Oracle APEX applications 2020.10
• Build Nested Interactive Reports 2020.10
• Preview Oracle cloud storage images in APEX 2020.10

Oracle APEX 20.2 如期而至，话不多说，一起来看看20.2的新特性！

以下是截止至 2020.09.30收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• On Close Tab Show Warning Message 2020.09
• Oracle Apex Collection Example 2020.09
• Display Image Item in Oracle APEX 2020.09
• Instant Row Delete in Oracle APEX 2020.09
• Need to extend Oracle APEX? Welcome Plug-ins Pro! 2020.09
• Getting started: Sign-up and install your first Oracle APEX Plug-in 2020.09
• Building a better Form in Oracle APEX: Instant validation and feedback on items 2020.09
• Add awesome checkboxes and status fields in an Interactive Grid in Oracle APEX 2020.09
• Adding a download (blob) link and context menu to your Interactive Grid in Oracle APEX 2020.09
• Power to the end-user! Create Interactive JET Charts in Oracle APEX 2020.09
• More Advanced File Uploads in Oracle APEX 2020.09
• Master-Detail Form Example on EMP and DEPT Tables 2020.09
• Including Images in Oracle APEX Emails 2020.09
• APEX REST Enabled Forms 2020.09
• PL/PDF or AOP which should I use? 2020.09
• Faster APEX get the browser to work for you 2020.09
• A Universal Theme Adventure: Header Height 2020.09
• PL/SQL Dynamic Content in Oracle APEX 2020.09
• Diving Into Master Detail Pages With APEX 2020.09
• Oracle APEX Application Import – Error Processing 2020.09

以下是截止至 2020.08.30收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）

常规APEX博文整理：

• Creating a Shuttle Item 2020.08
• Only allow numeric values as text input 2020.08
• Highlight cells based on value 2020.08
• Set a value in the “Search Field” from a previous page 2020.08
• Custom Authentication Scheme Part 2 2020.08
• APEX 20.1 nugget: Mega menu’s 2020.08
• Reacting on changed content of APEX Autocomplete Item 2020.08
• Oracle Apex Client-side Condition JavaScript Expression Example 2020.08
• Dynamic Action Submit Page Example 2020.08
• APEX_ITEM and checkbox processing the easy way 2020.08
• Disable Escape Key (ESC) to Prevent Close Dialog 2020.08
• Check if Item Value Changed 2020.08
• EXCEL like tables in Oracle APEX 2020.08
• Defining Link for Gantt Chart 2020.08
• Get Display Value from Select List 2020.08
• Dynamic Action to Show/Hide Region 2020.08
• Creating Card Layout Report with Images 2020.08
• How to Create a Change Password Page in Oracle APEX 2020.08
• Oracle APEX Logo And Text 2020.08
• How to Add Logo Top Left Corner in Oracle APEX 2020.08
• Add Region Background Image in Oracle APEX 2020.08
• Top 3 Oracle APEX Chrome Extensions 2020.08
• Confirm Password Validation in Oracle APEX 2020.08
• More info on Oracle Always Free APEX upgrades 2020.08
• Sorting in Oracle APEX reports (sequences) 2020.08
• When to AJAX Callback vrs. When to Dynamic Action 2020.08
• Creating A Mobile App From Scratch 2020.08
• Customising APEX built-in validation messages 2020.08
• Five Things To Love About Oracle APEX 2020.08
• More info on Oracle Always Free APEX upgrades 2020.07
• Show an additional scrollbar on top 2020.07
• Automatically activate the “edit” mode on page load 2020.07
• How to Clear Cache of a Page in Oracle Apex 2020.07
• Customizing Interactive Grid to improve your user’s productivity 2020.07
• Oracle APEX 20.1 - Require Change of Password on First Use 2020.07
• Bulk submit all region items to session state 2020.07
• CLOB in APEX Rich Text Editor 2020.07
• Flows for APEX 2020.06
• APEX 20.1 finally introduces the APEX_IG package 2020.03
• Custom Authentication Scheme Part 1 2020.03

在开始今天的分享之前先说一件高兴事儿，在小伙伴的努力和推荐下，钢哥有幸被 Oracle 评为今年的 Oracle ACE Director。很荣幸能跟各位行业大佬同框:)

https://apexapps.oracle.com/pls/apex/f?p=119297:3::::::

之所以说这个，是因为我觉得这个荣誉不是我一个人的，而是官方对 APEX 中文社区的认可，是对 APEX 中国用户组的肯定，也说明 Oracle 越来越重视 APEX 在中国的发展了。这对学习 APEX 的小伙伴绝对是一个好消息，也意味着后续 Oracle 会举行更多有关 APEX 的市场活动，届时肯定会第一时间通知大家。

更多关于 Oracle ACE 项目的信息，可以看这里：https://mp.weixin.qq.com/s/TENL6XdGADiEyNF18zNCzA

作为新晋的 ACED，当然要肩负起 APEX 在中国推广的重任了。正好有小伙伴邀请，希望能分享一些 APEX 方面的话题，所以就有了以下内容，算是抛砖引玉，供大家参考。