Skip to main content

Oracle Application Express

Search This Blog

IG- 1: Resources

on August 15, 2023

Get link
Facebook
X
Pinterest
Email
Other Apps

How to hack APEX Interactive Grid Part 1
How to hack APEX Interactive Grid Part 2
How to hack APEX Interactive Grid Part 3
How to hack APEX Interactive Grid Part 4

IG: Aggregate Validations
Interactive Grid button in toolbar based on a dynamic action

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

Processing multiple select list item in oracle apex

Multiple select list or Shuttle item type returns selected items in a single colon-delimited sting. e.g When return value is id: 1:5:3 When return value is string: val1:val3:val5 Examples: 1. Display employee details within the selected departments returned from a mulitselect list item/Shuttle item SELECT employee_name, job, salary, department_name FROM employee e, department d WHERE d.deptno = e.deptno AND instr(':'|| :P19_DEPTNO ||':',':'||e.deptno||':') > 0 2. Insert the selected values to a table from a multiselect list item/shuttle item DECLARE l_selected_items APEX_APPLICATION_GLOBAL.VC_ARR2; BEGIN l_selected_items := APEX_UTIL.STRING_TO_TABLE(:P19_DEPTNO); FOR i IN 1..l_selected.count LOOP INSERT INTO log_table(create_date, selected_dept) VALUES (sysdate, l_selected_items(i)); END LOO...

Using Google Fonts in Oracle APEX

In this blog we will explore how to use a different font than the default font in oracle apex. For demonstration purpose I am using google fonts CDN URL. Please visit https://fonts.google.com/ for fonts and choose a font of your choice. For this demo I choose "Audiowide" font. Click on the font name then click on the "Select This Font" link this will popup a window at the bottom of the page. Click on the the popup window, navigate to "@import" section. Copy on the URL "https://fonts.googleapis.com/css?family=Audiowide&display=swap". In oracle APEX navigate to the Shared Components > User Interface Attributes > User Interface Attribute , edit the Desktop UI, paste the URL in "File URLs" text box under cascading style sheet tab, now save and run the application. Click on theme roller on developer bar, open "Custom CSS" section and paste the following CSS code body, input { font-family: 'Audiowide',...

Global Page In Oracle Apex 18.2

A global page or previously page 0 is like a master page, all the components added to a page zero will be rendered in every page in an application by Apex engine. However you can restrict rendering of a component by defining conditions. In create page wizard if you are not getting the option of global page, that means you already have a global page added into your application. You cannot create process, branch and computations in global page. you can observe the Processing tab in page designer is blank unlike normal pages.

Powered by Blogger