Oracle APEX 系列文章10：Oracle APEX Evangelion（EVA 补完计划）

祁绪

2023-12-01

Neon Genesis Evangelion（EVA） is one of my favorite cartoons, I use Evangelion as the title to represent my respect for EVA. At meanwhile I wish this resource list would be the evangelion for Oracle APEXer all of the world.

Oracle APEX Learning Resources

Interactive Grid

Disabling Interactive Grid Columns 2018.05
Oracle APEX Interactive Grid Cheat Sheet 2018.03
APEX 5.2 Clipboard 2018.02
APEX and IG validation 2017.12
How to customize toolbar buttons 2017.10
APEX Interactive Grid: Column Widths and noStretch 2017.07
APEX Interactive Grid: JavaScript Basics Cheat Sheet 2017.07
APEX 5.1 IG toolbar customization 2017.05
Bulk Updating Interactive Grid Records 2017.03
How to hack APEX Interactive Grid Part 4 2017.03
How to hack APEX Interactive Grid Part 3 2017.02
How to hack APEX Interactive Grid Part 2 2017.01
How to hack APEX Interactive Grid Part 1 2017.01
Interactive Grid column widths 2017.01
Getting selected Rows in Oracle APEX Interactive Grid 2017.03
APEX: Updating Interactive Grid Cells 2017.03
Interactive Grids (Apex 5.1 EA) and TAPIs 2016.06
Interactive Grid: Under the Hood 2016.06

Interactive Report

APEX Reports: One Link, Multiple Destinations 2017.08
How to make a Custom Report Template 2017.04
How to make a Custom Card Template with Oracle APEX 2017.04
Checkboxes in Interactive Reports – Passing them via AJAX – Oracle APEX 2017.03
Interactive Report Alternating Rows 2016.11
Report Link: Save before Navigation 2016.10
How to Display a BLOB image in an APEX Report 2016.09
Fix Interactive Report headers issue when using a Region Display Selector 2016.08
Interactive Report with a Font Awesome edit icon 2016.07
Substitution Strings for IR Headers 2016.07
Reset Interactive Report (IR) 2016.06
APEX Master (Interactive Report) - Detail (Modal Dialog) Form: Conditional Column Link 2016.06
APEX Master (Interactive Report) - Detail (Modal Dialog) Form: Conditional Column Link 2016.06
Using dynamic tooltips in your Interactive Report 2016.05
Flag images in Apex reports and select lists 2016.05
Customising Interactive Reports through CSS and jQuery 2016.04
Coloring Cells in an Interactive Report 2016.01
Progress Bar in Reports in APEX 5 2015.12
Include action button in report 2015.12
APEX 5 Saved Interactive Reports – Primary Report Name Change 2015.11
Select all Checkboxes in Interactive Report 2015.10
Using JavaScript and APEX_JSON to Create an Editable IR Column 2015.10
Displaying images in a Report 2015.10
APEX Reports : Double click to edit 2015.09
Report Carousel in APEX 5 Universal Theme 2015.09
Report with Checkboxes 2015.09
APEX Interactive Report Checkbox Row Selection 2015.07
Implementing a Current Record Indicator in your APEX Reports 2015.05
gReport.search in APEX 5 2015.05
Reinventing APEX Reporting 2015.04
Understanding the APEX url - passing variables to items and (interactive) reports 2015.01
Oracle APEX private interactive reports lost post import of application 2013.09
Set Interactive Report Filter with URL Parameters 2012.01

Classic Report

That's a Classic Report? Really? 2018.02
Displaying info cards using an Oracle APEX named report template 2017.04
Hide nulls in Value Attribute Pairs report 2016.06

Report Print

Logging APEX Report Downloads 2018.04
Barcode lable printing using jquery with oracle apex 2017.04
Export your APEX Interactive Report to PDF 2016.06

Tabular Form

Oracle APEX | How to avoid insert same values into tabular form 2017.03
APEX plugin: make tabular report responsive 2016.05
Declarative Tabular Form dynamic totals 2016.04
Apex API for Tabular Forms 2016.02
Tabular Form – set default values with jQuery 2015.07

Notification & Message

Custom APEX Notification Messages 2018.03
Notifications Done Right – ApexNoti – Oracle APEX Browser Notifications 2017.03
Using APEX_ERROR to manage custom error messages 2017.01
Auto hide client-side messages 2017.06

Dialog

How do I Refresh a Region or Report after a Dialog is Closed? 2018.02
Warn Before Closing APEX Modal Dialogs 2017.04
Automatic resizing of modal dialogs 2016.12
Dynamic Modal Dialog Titles in APEX5 2016.11
Handling Dialog Cancel Event 2016.11
Close Modal Dialog When Clicking Outside 2016.07
Opening and Closing Modal Window - Part Two 2016.03
Showing a success message after closing a modal dialog 2015.09
The title of a modal dialog 2015.07
Opening and Closing Modal Window 2015.07
How to persist APEX dialog size and position 2015.06
APEX 5 Dialogs 2015.05
Modal Dialog Tips and Tricks 2015.10

Navigation Bar & Menu

Dynamic Navigation Bar 2018.01
APEX and Universal theme Navigation bar list 2017.11
Auto Expanding Menu on Hover 2017.09
Peeking at Collapsed Navigation Menu Entries 2017.08
Nice and Reponsive Navigation Bar With List / Report Content Part 1 2017.04
APEX 5 Hiding The Navigation Menu and Close a Menu by Clicking Anywhere on the Document 2016.08
Create a Navigation Bar based on a SQL statement 2016.06
Oracle APEX - Universal Theme Navbar Search 2016.05
Region in Left-side Navbar Menu 2016.04
Show Badges on Navigation Bar 2016.01
How-To: Dynamic Menus (Universal Theme) 2016.01
Adding Form Elements to the Navigation Bar 2016.01
Accordion-Like Navigation Menu 2016.01
APEX 5 Hiding The Navigation Menu 2015.11
Apex 5 - Minimize Left Sidebar Navigation by Default 2015.10
APEX 5.0 Custom Menus 2015.07

Region Display Selector & Tab

Tabs with Auto Height 2017.08
Region Display Selector Customizable for APEX 5.1 2017.05
Dynamic Selection of Tabs and Region Display Selectors in APEX 2016.09
My two favorite APEX 5 features: Regional Display Selector and Cards 2016.05
Working with Region Display Selectors in APEX 5 2016.05
Easy tab regions in Apex 5 2015.11

Tree

Add Checkbox Selection to APEX Tree Region 2017.04
Working with the Apex 5 treeview 2016.01

Shuttle

Accessing values from the left hand side of an APEX Shuttle 2015.05

Chart

APEX Chart as a time window filter 2017.10
Customising chart colours in APEX 5.1 2017.03
APEX Bubble Charts – Finding the Largest Bubble 2016.03

Button

Easier maintenance of standard APEX buttons 2018.02
Button in Region Title 2016.05

List

APEX Media List Mega Menu 2018.05
Detect Empty List 2015.11

Logo & Icon

APEX – Logo Text with Icon 2018.01
Pimp Your Forms - Post/Pre Text Icons 2017.11
How to use Font Awesome Icon in Placeholder 2016.07
ADDING A FAVICON TO APEX 2015.08

Text Editor

How do I create a responsive Rich Text Editor in Oracle APEX? 2017.12

Calendar

Refresh APEX Calendar 2016.02
Navigating through your APEX Calendar 2016.02

Map

Email

Email made Easier 2016.04
APEX_MAIL To Send a E-Mail & HTML Format link In APEX 2015.11
HOW TO SEND MAIL FROM ORACLE APEX 2015.10
APEX : Send email with attachment 2014.05
APEX : Send email with attachment (Part 2) 2014.05
Email Notification in Oracle APEX 2012.06
Email Notification in Oracle APEX 2012.06
Sending report as email attachment in Oracle APEX 2011.06
APEX_MAIL package 2010.09

Theme

APEX 5 Theme Boilerplate 2017.06
Dynamic Theme Style in APEX 5.1 2017.03
APEX Modify Universal Theme Breadcrumb 2016.06
Align topbar divs horizontally in Apex 5 Universal Theme 2016.06
APEX Universal Theme - Display Image in a List 2016.06
APEX Modify Universal Theme Breadcrumb 2016.06
Copy Theme Roller Theme From One Application to Another 2016.04
APEX 5 Verify Theme Subscription 2015.08

Plugins

How to mimic the APEX Builder profile menu with FOEX plugins 2017.05
Google Map APEX Plugins 2016.02
APEX 5.0 Packaged Application Plugins 2015.09

Login

APEX Login Background Image Cover 2017.08
APEX Login Page - Video Background 2017.08
APEX Login Background Image Cover 2017.08
Avoiding multiple logins from external Apex links 2017.06
Customising APEX 5.0 workspace login 2015.12
Customising APEX 5.0 workspace login 2015.12
Custom image on your APEX app login page 2015.09
APEX 5.0: pimping the Login page 2015.03

Session

How to debug/trace APEX session 2017.08
Apex 5 session cloning 2017.02
Setting item session state using AJAX in APEX 5 2016.11
Correlating APEX Sessions to Database Sessions 2016.09
about IDLE session timers in Apex 5 2016.07
APEX session isolation across multiple browser tabs - Problem Solved (in APEX 5.1) 2016.07
APEX 5 zip file support 2015.02
Clearing Session State in APEX 2015.01
Using SQL to view APEX session state 2013.01
Session State Protection in Detail 2012.11
How to Create an APEX Session in PL/SQL 2012.08
Googlebot, APEX Session IDs, and Cookies 2011.10
Variables in APEX 2011.01
APEX URL Format 2010.03

REST & JSON

One Thing You Need To Do Before Calling apex_web_service.make_rest_request 2018.05
ORDS and APEX – Common REST definitions at last 2018.02
Tips for parsing JSON in APEX 2018.02
Oracle APEX and RESTful API standards 2017.10
APEX Basic REST authentication 2017.07
APEX REST: Two Separate SQL Queries, One RESTful Endpoint 2017.03
Making & Consuming REST Web Services using ORDS & APEX 2016.08
Using the PayPal REST API from PL/SQL 2016.08
Consuming a REST Web Service returning JSON in APEX 2016.08
Securing Oracle Application Express when using Oracle REST Data Services (ORDS) 2016.07
Playing around with JSON using the APEX_JSON package 2016.04
Setting up and consuming your data securely with ORDS 2016.04
APEX REST POST 2016.03
Custom JSON in APEX 5 2015.12
How to consume a secured SOAP service using PL/SQL 2015.12
Generating JSON from SQL cursor 2015.09
IMPLEMENTING A REST API IN APEX 2015.08
Relational to JSON with APEX_JSON 2015.07
Relational to JSON with ORDS 2015.07
JSON for APEX Developers (part 3): Querying JSON in Oracle DB 12c 2015.04
JSON for APEX Developers (part 1) 2015.01
JSON for APEX Developers (part 2) 2015.01
Generate nested JSON from SQL with ORDS and APEX 5 2015.01
The APEX_JSON package: Generating JSON from PL/SQL 2014.07
The APEX_JSON package: Parsing JSON in PL/SQL 2014.06
Creating a REST web service with PL/SQL 2009.07

Javascript & AJAX

JavaScript async/await in APEX 2017.09
AJAX programming in Application Express 2017.01
Using APEX Javascript Events 2017.07
APEX AND ES6 - ARROW FUNCTIONS 2016.12
Client-side Messages in APEX 5.1 2016.12
Handling client-side messages in APEX 5.1 2016.12
Chunked multi-file upload with AJAX 2016.11
Return Page Item From an AJAX Callback Process 2016.10
Implementing Drag & Drop in your APEX applications 2016.08
APPLICATION PROCESSES, EXCEPTIONS AND THE HTTP STATUS CODE 2016.03
Calling PL/SQL from JavaScript in APEX 2015.12
HANDLING SIMULTANEOUS APEX.SERVER.PROCESS REQUESTS 2015.06
APEX and Asynchronous Ajax 2015.04
Passing more than 10 values with apex.server.process 2014.02
APEX_ERROR use case 2013.10
Ajax in Apex: introduction and techniques 2013.03
Getting and setting Apex page item values using v(), s(), v2() 2013.01

Dynamic Action

Delete a Row of a Report with a Dynamic Action 2018.03
Dynamic Navigation Bar (Table Based and Custom Settings) 2017.03
Sync or Async? Dynamic Actions in Application Express 5.1 2016.12
Synchronous Dynamic Actions in APEX 5.1 2016.06
Identify Fire on Page Load DA Actions 2016.03
Building Dynamic Actions in Oracle Application Express 5.0 2015.04
Trigger Dynamic Action from JavaScript 2014.10
Easy prototyping when using APEX DA triggeringElement 2014.06

Security

ORDS, OAuth2 & Web Services in APEX – Part 3 2018.01
ORDS, OAuth2 & Web Services in APEX – Part 2 2017.11
ORDS, OAuth2 & Web Services in APEX – Part 1 2017.10
Authenticate APEX via Token 2018.01
Using multiple Authentication Schemes for your APEX application 2017.10
Create a Custom Authentication and Authorization Scheme in Oracle APEX 2017.08
APEX Version Control & Team Working 2017.01
Using views with check option in APEX to protect your data 2016.05
How to set up IIS as SSL proxy for utl_http in Oracle XE 2016.04
Please, use HTTPS for your APEX apps 2016.05
Oracle APEX 5 Sentry Function 2016.01
Apex 5 Application Context 2015.11
Restrict Copy Paste & Right Click In APEX Page 2015.10
APEX 5 Change Workspace Authentication 2015.09
Enable Real Application Security (RAS) in APEX 5.0 2015.04
Enable network service (ACL) and Send mail from APEX 2014.12
Scripts for Setting Oracle ACL 2014.06
APEX and Application Contexts 2013.02
Apex Listener jdbc/security setup 2012.05
Add Expires Headers to your APEX Application 2012.03
Poor Man's VPD in APEX and Oracle XE 2010.07

Docker

Docker Oracle and APEX 2017.10
Dockerize your APEX development environment 2017.10

Installation

Others

Create formatted Excel file from your APEX cloud application 2018.05
Oracle Apex cache 2018.05
APEX_STRING: String-Operationen leicht gemacht! 2018.05
APEX Page Item Source vs Default 2018.04
How to Save Page Data but Show Errors in APEX 2018.03
Thoughts about the APEX_UTIL package 2018.03
Introducing APEX TabLock 2018.01
Keep the APEX builder tab and application tab in the same Firefox window 2017.10
Positioning items next to each other 2016.09
How to add a toolbar to an APEX page 2017.09
Bulk loading a template APEX application in a single workspace 2017.08
Alternative to prepare_url 2017.08
Read XLXS Files from APEX 5.0 and Higher – One (or Two) Ways 2017.06
APEX Client-Side Validation 2017.05
Changing the status of an Oracle Apex application with pl/sql 2017.03
Screensaver Effect in Oracle APEX Pages 2017.02
Right Side Column Page and Validation Error Message Region 2016.11
Clickable display only item 2016.11
Disabling Apex items the right way 2016.11
Interaction between two date fields 2016.11
Plotting Open Data with Oracle APEX 2016.11
Open a windows directory from inside your APEX application (IE, Firefox, Chrome) 2016.11
APEX 5.1: Show custom application icons in APEX Builder 2016.10
APEX URLs and HTML need not be in your SQL report queries 2016.10
Restore screen position after refresh 2016.09
How to set hotkeys for buttons in Oracle Apex 2016.08
Apex page call stack 2016.07
Apex APEX_ERROR API 2016.07
Oracle APEX Deployments: You’re Doing It Wrong 2016.07
Maximising Sub Regions in Internet Explorer 2016.07
Auto Selecting Text on Focus 2016.06
Checkbox Item check / uncheck all 2016.06
Beautifying File Browse Inputs 2016.05
Improving PL/SQL performance in APEX 2016.04
Warning APEX Users of Form Changes on Navigation away from the page 2016.04
Adventures in building a Form with APEX_ITEM 2016.03
Creating a Component Similar to Super LOV Using Native Components 2016.03
Watch out: validating number type items 2016.03
Let’s wreck the default Fire on page load option 2016.03
Automated export and import of APEX applications via command line 2016.03
Add browser recognition on page inline CSS 2016.03
Apex API – call a package for all your DML 2016.02
Accepting payments with Stripe in APEX, Part 3 2016.02
Running an Oracle APEX application against MongoDB 2016.02
Accepting payments with Stripe in APEX, Part 2 2016.02
Accepting payments with Stripe in APEX, Part 1 2016.02
BUILDING AN ANGULARJS PAGE IN APEX 2016.01
Formatting a Download Link 2016.01
Oracle APEX & Multi-Tier 2015.12
Apex 5 right side column 2015.11
APEX 5 Adding a Marquee Region 2015.11
A nifty way to refresh page regions in Oracle APEX 2015.11
Refreshing PL/SQL Regions in APEX 2015.11
Media player in APEX 2015.11
Auto-convert field to uppercase 2015.08
Enhancement to waitPopup on APEX 5 2015.08
Disable IE Compatibility Mode 2015.08
Remove punctuation from string using Javascript 2015.07
showing an “Under Maintenance” web page 2015.07
APEX Item Submission 2015.07
AJAX Callback and jQuery creating Page Items Dynamically 2015.06
APEX Instance debugging on command line 2015.06
How to translate my application in Oracle Apex 5 2015.04
JavaScript Debugging in APEX 5 2015.04
APEX ReadOnly Pages - The easy way 2015.03
Oracle Apex 调试技巧 2014.11
prevent a duplicate page submit 2014.10
Change the owner at runtime in Apex 2014.09
Show an animated “Please wait” indicator after page submit 2014.09
APEX Tip: Page Items to Submit 2014.07
Recognize your APEX dev, qa and prod environments 2014.03
human readable URLs in Oracle APEX – Part 2 2013.12
Drag and drop an excel file to an APEX collection 2013.08
Apache Rewrite for Oracle Apex Application 2012.04
Using websockets in APEX for automatic refresh with nodejs 2012.04
Workspace, application and page export in PL/SQL 2012.03
Mobile Device Detection in Oracle APEX 2011.10
APEX built-in variables 2011.04
Nice URL in a Public Facing Oracle APEX Application 2010.02

Oracle Learning Library

Kenny's Oracle APEX Series