Skip to main content

Oracle Application Express

Search This Blog

IG- 1: Resources

on August 15, 2023

Get link
Facebook
Twitter
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
Twitter
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 LOOP; END ; Ref: Oracle Apex Documentation

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',

Embed Youtube video in Oracle APEX

If you wish to embed a youtube video in an oracle APEX page the process is very straight forward. 1. Create a Static Content region in a page. 2. Go to youtube, click on the share button on the video you wish to embed in the page. 3. On the popup region click on the "Embed" button and copy the iframe code 4. Paste the code in "Text" property of the "Static Content" region you have created 5. Well-done! You can run the page and can play the video. It all worked fine, but when I have added the video in a Modal dialog page, I could not run it in full screen mode in Mozilla Firefox browser, however it's worked fine when I changed it to non-modal dialog page. Please let me know if you have any reason or solution for this issue. Thanks! Happy Coding!!!

Powered by Blogger