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