Oracle apex Article 10: Oracle apex Evangelion (EVA completion plan)

Time:2020-5-2

Oracle apex Article 10: Oracle apex Evangelion (EVA completion plan)

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

  • 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 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 debugging skills2014.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 series article 1: Oracle apex, let you change the black technology of full stack development in seconds
  • Oracle apex series article 2: build your own apex full development environment on Alibaba cloud (install CentOS)
  • Oracle apex series article 3: build your own apex full development environment on Alibaba cloud (install tomcat, nginx)
  • Oracle apex series article 4: build your own apex complete development environment on alicloud (install Xe, ords, apex)
  • Oracle apex series article 5: build your own apex complete development environment on Alibaba cloud (further optimization)
  • Oracle apex Article 6: is Oracle apex suitable for enterprise environment?
  • Oracle apex Article 7: new features of Oracle apex 18.1
  • Oracle apex Article 8: how to upgrade from apex 5.1.4 to the latest apex 18.1
  • Oracle apex Article 9: why Oracle apex
  • Oracle apex series article 10: Oracle apex learning resources collation

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 Article 10: Oracle apex Evangelion (EVA completion plan)
Wang Fanggang Oracle apex Evangelist

Recommended Today

The selector returned by ngrx store createselector performs one-step debugging of fetching logic

Test source code: import { Component } from ‘@angular/core’; import { createSelector } from ‘@ngrx/store’; export interface State { counter1: number; counter2: number; } export const selectCounter1 = (state: State) => state.counter1; export const selectCounter2 = (state: State) => state.counter2; export const selectTotal = createSelector( selectCounter1, selectCounter2, (counter1, counter2) => counter1 + counter2 ); // […]