
How to Show Recently Viewed Records in Oracle APEX
Store per-user page views in one table with a MERGE in a Before Header process, and show each user's last 10 viewed records with a classic report in Oracle APEX.
Oracle APEX (Application Express) is a low-code development platform for building scalable, secure enterprise applications. It allows developers to quickly create web-based applications using a browser-based interface, reducing the need for extensive hand-coding.
For a more structured learning journey, you can also explore the Oracle APEX Roadmap for a sequential path through related concepts, features, and development topics.

Store per-user page views in one table with a MERGE in a Before Header process, and show each user's last 10 viewed records with a classic report in Oracle APEX.

Store per-user favorites in one table, toggle a star in each report row with an Ajax Callback, and filter the report to the current user's favorites in Oracle APEX.

Store per-user notifications, show the unread count on a navigation bar bell, list them in an Inline Drawer and mark them as read with Ajax in Oracle APEX.

Store announcements with start and end dates, show them on every page from the Global Page with the Alerts template, and let each user dismiss them in Oracle APEX.

Add per-user and shared counts to the side navigation menu with restricted application items, Before Header computations and square-bracket labels in Oracle APEX.

Cache a shared summary and a per-user list with Server Cache, show the cache date, purge it with APEX_REGION, and avoid cached buttons in Oracle APEX.

Turn on Lazy Loading for a slow report, compare page load times before and after in the activity log, and see what a failing lazy region shows in Oracle APEX.

Add date pickers that refresh a chart and a report, a chart type switch that keeps the user's choice, and checks for wrong or forged ranges in Oracle APEX.

Build an Oracle APEX line chart that compares each month with the same month last year, with percentage tooltips, a fair current month and empty months shown as 0.

Show counts by weekday and hour as a colored grid in Oracle APEX, with every empty hour shown as 0, a legend, a channel filter and checks against SQL.

Build an Oracle APEX combination chart with actuals as green or red bars and the monthly target as a line, with filters and months without data shown as 0.

Prepare cumulative funnel numbers in a view, show them in an Oracle APEX Funnel chart with labels and tooltips, and list the records behind each section.

Add a drag handle to a classic report, reorder rows with jQuery UI Sortable, and save all positions in one MERGE that refuses outdated or forged lists.

Chain three Interactive Grids with Master Region and Master Column, add a page Save button, and store a new parent with its children and grandchildren in one submit.

Copy spreadsheet rows into an editable Interactive Grid with Paste Insert, map names to IDs in a PL/SQL save process, and validate every pasted value.

Keep key columns in view while users scroll a wide Interactive Grid: freeze from the column menu, save the default report, and keep personal layouts in private reports.

Build an editable Interactive Grid that opens in cell selection mode, fill and copy values across many rows, lock finished rows, and validate the bulk changes on save.

Build a multi-select popup with a row selector, return the ticked rows with Close Dialog, and insert or update grid rows through apex.model.