Oracle APEX 活跃博文整理 | 2020.03.30
以下是截止至 2020.03.30收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）
常规APEX博文整理：
- Oracle APEX Version Control From SQL Developer
2020.03 - Inserting Records into Interactive Grid Using JavaScript
2020.03 - Let User Select the Theme of His Choice
2020.03 - Auto Refresh Report After a Specified Interval
2020.03 - Error Handling Function Example
2020.03 - Hide Processing Spinners Displayed by Dynamic Actions
2020.03 - Oracle Apex Function Returning SQL Query Example
2020.03 - Oracle Apex: Loop Through Interactive Grid Records
2020.03 - How to show dates in a given time zone when the value is stored in a DATE data type
2020.03 - APEX 19 Form PL/SQL Processing
2020.03 - Using REST Data Sources for APEX List of Values
2020.03 - APEX Authentication Options
2020.03 - Top WOW Features of APEX
2020.03 - Oracle Supported EBS extensions with APEX – Simply explained
2020.03 - Inspect Element Deep Dive, with Oracle APEX
2020.03 - Tweaking Classic Reports
2020.03 - APEX Navigation Menu Experiments Part 2
2020.03 - APEX Navigation Menu Experiments Part 1
2020.03 - Next/Previous Record: how APEX does it
2020.03 - Loading large GeoJSON objects
2020.03 - APEX Media Extension (AME) Publicly Available
2020.03
通过AWS CLI自动替换EC2实例IP地址
背景
平时在AWS EC2上跑了点东西，方便查学习资料（你懂的）。之所以选择AWS是因为它家提供1年免费套餐，另外海外节点稳定。起先一切看起来不错，可以实现自由冲浪。
但过不了多久就会被 王府井 屏蔽，没办法，多启几个容器吧（内存有限，一次启用5个不同的端口，发现不好用时手工切换本机客户端端口呗，5个端口都换完了就重新绑定个弹性IP，也算个解决办法。
但最近发现， 王府井 的效率变高了。基本上只要访问过一次受限网站，过不了几分钟这个端口就被封了，这让我怎么学习？没办法，不得不重新更换一个新的弹性IP地址。更换IP地址的过程是这样的：
- 登录AWS控制台（国内访问速度比较慢）
- 切换到EC2控制面板
- 分配新的弹性IP地址
- 将新地址绑定到EC2实例
- 释放旧的IP地址
一轮操作下来，一般要十几分钟。有时候半天登录不上，痛苦啊啊啊。。。
每次重复劳动，对于我这个希望用行动改变世界的码农来说，不是我性格啊。趁今天有空，研究了一下如何用AWS命令行工具（AWS CLI）自动替换EC2实例的弹性IP地址，节省我的时间。
Oracle APEX 活跃博文整理 | 2020.02.29
Oracle官方免费教程更新了，内容涵盖APEX认证、针对老师学生的免费资源，而且Oracle现在也在Github上推出了一些实验课程，大家可以从以下链接进去。
- Oracle APEX 19.2 Free Curriculum Now Available!
- Oracle APEX 教育资源
- Oracle Academy Courses
- Oracle APEX 认证考试
- Oracle APEX Hands-On Lab
New
以下是截止至 2020.02.29收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）
常规APEX博文整理：
- Quick SQL Primary Key Generator
2020.02 - Allow Only Numbers and Decimal Using jQuery in Oracle Apex
2020.02 - Allow Only Integer Value Using jQuery
2020.02 - Dynamic Action Execute JavaScript Code Example
2020.02 - Creating Incremental Search for Reports
2020.02 - Creating On/Off Toggle Switch Using HTML,CSS and JS
2020.02 - Creating Tab Pages
2020.02 - Using Server-Side Conditions
2020.02 - Create Sticky Buttons Container for Dialog Windows
2020.02 - Reload/Refresh Page Using JavaScript
2020.02 - Calculate Field Values Using JavaScript
2020.02 - Set Value Dynamic Action Examples
2020.02 - Iterating OCI CLI list data in bash
2020.02 - Oracle Cloud Infrastructure Cloud Shell - Here’s what I discovered
2020.02 - Optimizing MEMBER OF with APEX_STRING.SPLIT
2020.02 - How to Find APEX Built-in Substitution Strings
2020.02 - Changing the Maximum Session Idle Time in APEX
2020.02 - APEX IR Saved Report Aliases
2020.02 - Upgrading to Nice Switch in APEX 19
2020.02 - How to Reduce Width of IR Link Column in APEX
2020.02 - APEX Component Settings for Switch
2020.02 - Oracle APEX Geolocation 1: How to get your location
2020.02 - Free Oracle Cloud: 19. Oracle APEX upgrades (19.1 to 19.2)
2020.02 - Forms to APEX: The Last Enhancements
2020.02 - Forms to APEX: Customizing the APEX Application - Orders Form
2020.02 - Sending Email from your Oracle APEX App on Autonomous Database
2020.02 - Forms to APEX: Customizing the APEX Application - Customers Form
2020.02 - OCI CLI Environment Variables
2020.01 - Forms to APEX: Creating the APEX Application
2020.01 - Forms to APEX: Creating a Migration Project
2020.01 - Forms to APEX: Converting FMBs to XML
2020.01 - Modernizing an Oracle Forms Application to an Oracle APEX Application
2020.01 - Using Build Options
2020.01 - Beginners Guide to List of Values in Oracle APEX
2020.01 - Add a Chart to your Faceted Search Page
2019.12
使用Oracle Data Pump将数据库迁移到AWS RDS Oracle数据库
钢哥注：本文是对AWS官方博文《使用Oracle Data Pump将数据库迁移到AWS的RDS Oracle数据库》的整理，原文请点击 这里。
Web Application Hosting in the AWS Cloud - AWS白皮书 中文翻译
钢哥注：本文是对AWS白皮书《在AWS上托管Web应用程序》的中文翻译，原文请参考这里：《Web Application Hosting in the AWS Cloud》。
Oracle APEX 活跃博文整理 | 2020.01.30
以下是截止至 2020.01.30收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）
常规APEX博文整理：
- Printing to local (Zebra) printer from Oracle APEX in the Cloud
2020.01 - Print PDF from Oracle APEX to Local or Remote Printer
2020.01 - [Forms to APEX] Creating the APEX Application
2020.01 - Oracle APEX image gallery
2020.01 - Performance on Classic Reports with LOVs
2020.01 - Unpivoting Oracle APEX meta-data
2020.01 - Display Custom Error Messages from PL/SQL Process
2020.01 - Resolve “Session State Protection Violation” Error in Oracle Apex
2020.01 - Download BLOBs with SQL*Plus
2020.01 - Create Dynamic Links For Interactive Reports In Oracle APEX
2020.01
Oracle APEX 活跃博文整理 | 2019.12.28
以下是截止至 2019.12.28收集的 Oracle APEX 最新博文，完整博文列表请移步这里：Oracle APEX Evangelion（EVA 补完计划）
常规APEX博文整理：
- Universal Buy-In With Data Visualization In Oracle APEX
2019.12 - Displaying CLOB Contents in Oracle Apex
2019.12 - Mask Password Using CSS
2019.12 - Translation enhancements in APEX 18 and 19
2019.12 - Developing Secure Web Applications with APEX and ApexSec
2019.12 - Include new APEX templates in an older APEX instance
2019.12 - On the PL/SQL you don’t write when using APEX
2019.12 - All the Things That Pop Up
2019.12 - 15 Top Tips to tune your Oracle APEX Performance
2019.12 - Extending interaction to Interactive Grids - Part II
2019.12 - Free Oracle Cloud: 18. Monitoring your website and APEX app
2019.12 - Free Oracle Cloud: 17. Configure domain to redirect to APEX app
2019.12 - The best way to be productive with APEX Office Print (AOP)
2019.12 - Alternative for Oracle Multimedia: APEX Media Extension
2019.12 - Free Oracle Cloud: 16. Renewing Let’s Encrypt certificate
2019.12