Oracle APEX 活跃博文整理 | 2021.09.29
以下是截止至 2021.09.29
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
- Announcing Flows for APEX 21.1
2021.09
- Oracle Autonomous Database Vanity URLs Part 2: Blocking Developer and Administrator Tools
2021.09
- Introducing Vanity URLs for APEX and ORDS on Oracle Autonomous Database
2021.09
- ORDS, APEX and secure REST APIs (Part 2 – call the API)
2021.09
- ORDS, APEX and secure REST APIs (Part 1 – secure the API)
2021.09
- Return value of a modal in an Interactive Grid IG - Oracle APEX
2021.09
- The network adapter could not establish the connection
2021.09
- Ords 503 Service Unavailable
2021.09
Oracle APEX 系列文章18:如何利用REST数据源进行APEX开发
前言
在现实工作中,很多时候需要将第三方的系统数据集成到自己的系统中,但第三方系统使用的数据库不是Oracle数据库,甚至不在本地局域网内,无法简单地通过数据库直连
的方式集成到APEX中。但对方可能会提供基于http的接口,如: SOAP Web Service或者RESTful风格的API。
钢哥注: 不了解REST API与SOAP的区别的可以看这里:比较SOAP与REST API
其实,APEX提供将RESTful API作为数据源的能力,这种方式可以不用管后端数据源是什么数据库,只要通过合法调用RESTful API,即可实现对远端数据的增删改查(前提是对方得提供增删改查的RESTful API),甚至可以实现定时同步远端数据(到本地表),从而扩展APEX数据源。很多APEX标准控件(如:Interactive Grid,Interactive Report, Classic Report)都支持使用REST作为数据源,开发者无需关心背后的数据是否来自”本地“,就可以像使用本地表一样进行页面开发,可以说还是非常不错的。
下面就跟钢哥一起揭开APEX使用REST Data Source的神秘面纱吧。
Oracle APEX 活跃博文整理 | 2021.08.31
以下是截止至 2021.08.31
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
- Github: fuzziebrain/docker-apex-stack
2021.08
- IG Hack - #4, Change the column width of Interactive Grid using JavaScript in Oracle APEX
2021.08
- How to connect Oracle APEX with Google Drive
2021.08
- Oracle APEX: how to create a web application in 5 minutes
2021.08
- Implementing AJAX in Oracle APEX requests
2021.08
- Oracle APEX JavaScript - Get Column Value
2021.08
- Autonomous DB “You have exceeded the maximum number of web service requests per workspace”
2021.08
- Document Management System in Oracle APEX
2021.08
- Add Emojis in Oracle APEX
2021.08
- New Plug-in: Reacting on changed content of APEX Autocomplete Item
2021.08
- Uploading Files to OCI Object Storage from Autonomous
2021.08
- A note on using a numerical sys_guid with JavaScript
2021.08
- how to create an APP To-Do List
2021.07
Oracle APEX 活跃博文整理 | 2021.07.31
以下是截止至 2021.07.31
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
- Oracle APEX + Server-side JavaScript
2021.07
- Oracle PL/SQL MD5 Checksum for a BLOB
2021.07
- After Login Redirect the User to a Specific Page
2021.07
- Creating Breadcrumbs in Oracle Apex
2021.07
- Oracle Apex Suppress Leave Site Warning Message
2021.07
- Hiding spinning icon in APEX 21.1 Modal Dialog
2021.07
- Differences between APEX 20.2 and 21.1
2021.07
- APEX API Tracer
2021.07
- An APEX Plugin for download of Interactive Reports as ZIP files
2021.06
- REST Data Sources/Synchronization deployment tips in APEX 20.2
2021.06
- Oracle APEX Low-Code Authentication and Authorization
2021.06
- Oracle APEX Low-Code User Management – Part II
2021.06
- Oracle PL/SQL Storing Large Objects on AWS S3
2021.06
- REST Data Sources/Synchronization deployment tips in APEX 20.2
2021.06
- Oracle PLSQL Template for RESTful API
2021.05
- APEX Debug Messages – Standardize error collection, debugging and trace
2021.05
- Querying JSON with Oracle SQL
2021.05
- The APEX Slideover Plug-In
2021.05
Oracle APEX 活跃博文整理 | 2021.06.30
Oracle APEX 活跃博文整理 | 2021.05.31
5月份的博文比较少,可能大家还沉寂在缅怀 Joel Kallman 的悲痛中。虽然与Joel没有直接打过交道,但参加过几次APEX Hour活动, 也多次拜读过他的博客文章。Joel绝对算APEX的灵魂人物,希望天堂没有新冠,也希望APEX在中国开枝散叶能让他的在天之灵感到一丝欣慰。
以下是截止至 2021.05.31
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
Oracle APEX 活跃博文整理 | 2021.04.30
以下是截止至 2021.04.30
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
- Top Oracle APEX plug-ins we love and use
2021.04
- Building a REST API to Deploy APEX Apps
2021.04
- Setup the APEX Office Print (AOP) Server with the Oracle Cloud APEX Service
2021.04
- Which one to pick: Free APEX Service vs Free Oracle Autonomous DB
2021.04
- APEX Map Region vs. Google Map Plugin
2021.04
- Oracle APEX Interview With Jackie McIlroy, APEX Boss
2021.04
- Setting The Value Of A Popup LOV Page Item Via IG
2021.04
- Two ways to fetch the current records (Interactive Grid #10)
2021.04
- Oracle APEX and Stripe v3 - part 3
2021.04
- Oracle APEX and Stripe v3 - part 2
2021.04
- Oracle APEX and Stripe v3 - part 1
2021.04
- Install Oracle APEX, ORDS and Tomcat on Google Cloud Platform - Compute Engine - CentOS 8 - DB 18c Express Edition Part 4
2021.04
Oracle APEX 活跃博文整理 | 2021.03.31
以下是截止至 2021.03.31
收集的 Oracle APEX 最新博文,完整博文列表请移步这里:Oracle APEX Evangelion(EVA 补完计划)
常规APEX博文整理:
- Oracle APEX Named a 2021 Gartner Peer Insights Customers’ Choice for Enterprise Low-Code Application Platforms
2021.03
- Synchronize Parent-Child REST Sources
2021.03
- Design Simple and Attractive Login Page in Oracle APEX
2021.03
- Unchecked Checkbox When Another Is Checked in Oracle APEX
2021.03
- Enable Multiselected feature of Oracle APEX Tree
2021.03
- Customize your Toolbar (Interactive Grid #9)
2021.03
- Customize the Column Heading Menu (Interactive Grid #8)
2021.03
- Read-Only/Disable Switch Widgets In Oracle APEX
2021.03
- Lose Focus DA And Submit Page In Oracle APEX
2021.03
Oracle APEX 活跃博文整理 | 2021.02.28
以下是截止至 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