Oracle APEX

  • jQuery Events for APEX & PL/SQL developers

    DOM selection and manipulation in jQuery is essential for identifying web page components. Event handling facilitates interaction with these identified components by the end users by responding to their input devices.

    Touch screens have turned the user’s fingers into input devices and events such as those responding to gestures are handled specifically with jQueryMobile—a framework for creating mobile applications. APEX applications don’t need to include the mobile framework to handle standard tap and scrolling events. A small library called Touch Punch can be included on a web page to make it respond to dragging gestures, useful for slider items.

  • jQuery Fundamentals for APEX PL/SQL programmers

    Mastering the concept of selectors is a difficult part of learning jQuery. There are a number of methods to identify the right page element to act upon. In addition to the selectors mentioned in this blog, jQuery also provides the ability to traverse up and down the HTML tree using specific functions.

    More detailed examples of selectors will be introduced as the blog details traversal methods in addition to other fundamental concepts and common features. Just like SQL, a good percentage of what you’ll ever need to do will already have an appropriate documented function.

  • Oracle Apex and jQuery integration from the Box

    jQuery has been included by default in Oracle APEX applications since the advent of dynamic actions. The application builder provided wizards to define event handlers that interact with page components.

    In addition to dynamic actions, Oracle APEX provides the ability to utilize other jQuery features declaratively. For instance, date pickers and autocomplete items use the jQuery framework. Many types of APEX plug-ins also use the jQuery library to function.

  • Oracle Application Express (APEX) for Oracle OLAP

    Oracle APEX for Oracle OLAPOracle Application Express (APEX) is a web-based application development and deployment tool that comes with the Oracle Database. Developers can use it to create reliable, secure, and easy-to-maintain web applications. The built-in wizards and functionality make it possible to build applications rapidly using relational and Oracle OLAP data. Since the Oracle OLAP data can be represented as SQL views, it is now easier than ever to report on the Oracle OLAP data. By using conditions on the SQL queries, it is possible to return data without the need to use aggregation functions. This greatly increases the performance of querying and retrieving data.

  • Packaged APEX Applications

    APEX Packaged ApplicationsAn APEX application can consist of many components: the application code, the database objects (tables, triggers, sequences, and so on), and even static files such as custom images or CSS files. When moving your applications to another environment, you have to consider whether you need to move these components as well.

    When moving your application, you’ll deal with the following three main deployment scenarios, in order of complexity:

    •    Copying your application in the same workspace
    •    Moving to a new workspace that uses the same schema
    •    Moving to a new workspace that uses a different schema
    • What Is APEX?

      What is Oracle Apex RAD toolAPEX is a 100% browser-based rapid application development (RAD) tool that helps you to create rich, interactive, Oracle-based web applications very quickly and with relatively little programming effort.

      There are many RAD development tools and platforms on the market. If you’re dealing with data that resides in an Oracle database, a number of things make APEX distinctive and thus more attractive as a development platform. First and foremost, APEX is built on and uses as its core languages SQL and PL/SQL. This is a huge advantage for those of you who have already been working with the Oracle database, because it means you can immediately draw on what you know. Even if you don’t have an Oracle background, but are going to be working with an Oracle database, you need to learn about its particular flavor of SQL and will at some point likely find a need for the PL/SQL procedural language.