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

wfg2513148

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

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 ResourcesInteractive 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

• Oracle APEX Interactive reports and google maps integration 2018.05
• Introduction to Implementing Google Maps in Oracle APEX Applications 2017.02
  

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 apexwebservice.makerestrequest 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

• Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7: all-in-one guide - introduction 2018.03
• Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7: all-in-one guide - part two 2018.03
• Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7: all-in-one guide - part one 2018.03
• Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7: all-in-one guide - part three 2018.03
• Oracle Application Express (APEX) 5.x Installation 2017.03
  

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

• Transitioning to Oracle Application Express 5.1
• Installing and Running a Packaged Application in Oracle Application Express 5.1
• Adding Charts to your Existing Database Application in Oracle Application Express 5.1
• Creating an Application Express Database Application from a Spreadsheet
• Adding Security to your Database Application Using Oracle Application Express 5.1
• Using Interactive Grid Regions in Oracle Application Express 5.1
• Translating an Application in Oracle Application Express 5.1
• Building Dynamic Actions in Oracle Application Express 5.1
• Building a Mobile Web Application Using Oracle Application Express 5.1
• Building a Websheet Application in Application Express 5.1
• Building and Customizing an Interactive Grid in Oracle Application Express 5.1
• Creating PDF Reports with Oracle Application Express 5.1 and Oracle REST Data Services
• Creating a Data Load Wizard for Your Application with Oracle Application Express 5.1
• Creating and Using a RESTful Web Service in Application Express 5.1
• Modifying the Universal Theme by using Theme Roller in Application Express 5.1
  

Kenny's Oracle APEX Series

• Oracle APEX 系列文章1：Oracle APEX, 让你秒变全栈开发的黑科技
• Oracle APEX 系列文章2：在阿里云上打造属于你自己的APEX完整开发环境 (安装 CentOS)
• Oracle APEX 系列文章3：在阿里云上打造属于你自己的APEX完整开发环境 (安装 Tomcat, Nginx)
• Oracle APEX 系列文章4：在阿里云上打造属于你自己的APEX完整开发环境 (安装XE, ORDS, APEX)
• Oracle APEX 系列文章5：在阿里云上打造属于你自己的APEX完整开发环境 (进一步优化)
• Oracle APEX 系列文章6：Oracle APEX 到底适不适合企业环境？
• Oracle APEX 系列文章7：Oracle APEX 18.1 新特性
• Oracle APEX 系列文章8：如何从 APEX 5.1.4 升级到 最新的 APEX 18.1
• Oracle APEX 系列文章9：为什么选择使用 Oracle APEX
• Oracle APEX 系列文章10：Oracle APEX 学习资源整理
  

Oracle APEX Active Blogs

• http://vmorneau.me
• http://rimblas.com/blog
• http://apexbyg.blogspot.sg
• http://lschilde.blogspot.sg
• https://dickdral.blogspot.jp
• http://max-tremblay.blogspot.jp
• https://blogs.oracle.com/apex
• https://thtechnology.com
• http://dgielis.blogspot.sg
• https://emoracle.wordpress.com
• http://www.grassroots-oracle.com
• http://hardlikesoftware.com/weblog
• http://www.explorer.uk.com/blog
• https://ruepprich.wordpress.com
• http://davidsgale.com
• http://joelkallman.blogspot.hk
• https://www.talkapex.com
• http://nuijten.blogspot.nl
• https://www.odtug.com/apex
• https://ora-00001.blogspot.sg
• https://apextips.blogspot.sg
• http://spendolini.blogspot.sg
• https://wangfanggang.com
  

---

王方钢 | Oracle APEX Evangelist