Here is an excellent quick tutorial on how to use the Git plugin for Sublime.
Please take a look a Joel Kallman’s post about how secure APEX is. The comments below are interesting as well: Let’s Wreck This Together…with Oracle Application Express!: Is Oracle Application Express Secure?
A colleque of mine recently had the wish to be able to control the state of a collapsible region using a page item.
This is how a simple report region using the “Collapsible” region template looks like.
We now want to control the state of the region by a page item. For example if the item is NO or 0 then the region should be expanded, if it is YES or 1 then the region should be collapsed.
There are three general options how to do that.
- Simulate the click on the region button
- Dynamically switch css classes
- Set the template option based upon some page item value
I’ll show how to implement all three possibilities.
There is also demo on https://apex.oracle.com/pls/apex/f?p=21878 to show the different options.
Option 1: click the button
First we create a page item that should influence the state of our region. I’ve…
View original post 655 more words
Carsten Czarski wrote an excellent post on how to use the APEX_JSON package included in APEX 5, to generate JSON from table data. The post can be viewed in English by clicking the Show posts in english link at the top.
On a report, I needed to display a delete icon, that changes colors on hover. Here is how I went about it:
In the report, I set the the Customer ID column to type Plain Text. And added the following code to the HTML Expression:
<span class=”delIcon fa-stack”>
<i class=”fa fa-square-o fa-stack-2x”></i>
<i class=”fa fa-remove fa-stack-1x” style=”line-height: 20px;”></i>
I got the code snippet from the FontAwesome website. It simply stacks two fontawesome icons on top of each other. I added the class dellIcon to the span, so I could control the color and the hover behavior.
The following CSS adds the color and the hover color to the icon:
Filip Van Vooren created browser extensions for Chrome and Firefox to allow you to customize the APEX 5 page designer.
Check out his blog post for details.
This is a proof of concept for a multiplayer game in Oracle APEX. Players log into an APEX application and choose a team (Blue/Red). Then the game presents each player with a page and a randomly chosen math problem. The page however is “locked” by a modal page telling the player that the game is paused.
The button the the Raspberry Pi controls the game state: Stopped, Ready, Running. When the game is stopped or ready, the player’s screens are blocked with the modal window.
A breadboard with a LED and two buttons is connected to the Raspberry Pi (the blue button doesn’t do anything).
The red button cycles through the games states. When the game is in Running state, the modal window goes away, and the players can answer the math question. When the button is pressed again, the game goes into Stopped state, and the modal window pops up, preventing the players from answering more questions.
In addition, the LED also shows the game state: Off- game stopped, Blinking – ready, On – running.
This video shows me cycling through the three game states. There are four players connected: Red team on phones, Blue team on separate browsers.
At first the game is Stopped (LED off, modal window up), the first button press puts the game in Ready state (LED blinks, modal window up). The second button press puts the game in running state (LED on, modal window disappears). The final button press puts the game back int Stopped state (LED off, modal window up).
To change the size (height/width) of a modal dialog page in APEX 5, edit the modal page’s page attributes, and edit the attributes of the Dialog section: