When I setup an application, I usually use Dimitri Gielis' method, so instead of using "real tabs", I use a List and display that list as Tabs.
For each of the "Tabs", I also create Page Groups, just to keep things organized. (more...)
Read and monitor Oracle related blogs and news sources, all in one place.
I’ve been doing apex for about 7 years now, and along the way I discovered a few things that made my life as a developer a lot easier. I made a list of 5 things thar I wish I had known wen I just started. Those things will be explained to you in a series of 5 posts.
One of the most tiresome things to do when managing multiple applications is to keep things like (more...)
I had a registration form in Apex which asks the applicant to enter their Date of Birth in a date item; I then needed to calculate how old they would be at the start of the event, which determines a number of rules, such as whether we need to obtain their parent’s permission.
In my first release I implemented this with a Dynamic Action which ran SQL something like this:
select round(months_between(start_date ,to_date(:P1_DATE_OF_BIRTH,'DD-MON-YYYY')) / 12,1) from (more...)
Using SQL Developer to export or import an Apex application is not only easy, it’s also fast!
To export, follow these steps:
Open the connection to the schema where you’re application is located and search for the “Application Express” directory:
Right click on the application you want to export and choose “Quick DDL” > “Save to File…”:
When done, you’ll have the same file as you would have exported from the Apex GUI.
Since APEX 4.2, there is a way to do this easily.
We start by creating the application process (more...)
Seamless cloning of an application stack is an outstanding goal. Seamless cloning of an application stack including the full production database, application server, and webserver in a few minutes with next to zero disk space used or configuration required is the best goal since Alexander Graham Bell decided he wanted a better way tell Mr. Watson to “come here.”
CREATE TABLE seq_test(a NUMBER)
ALTER TABLE seq_test MODIFY (a NUMBER DEFAULT sage_seq.NEXTVAL)
SQL Error: ORA-02262: ORA-2289 occurs while type-checking column default value expression
*Cause: New column datatype causes type-checking error for existing column
default value expression.
*Action: Remove the default (more...)
Now the Oracle REST Data Services 3.0 Early Adopter is available, let us have a look how it’s to be installed in Weblogic 12c!
I’ve ommitted the installation or upgrade of Apex here as there is plenty of documentation on that topic, and the ORDS can be applied for other uses than being an Apex Listener since v2.0.4.
Download the Application Express and ORDS 3.0 installer from the Oracle (more...)
Dec. 2, 2014 marked the first ODTUG Oracle Mobile Day, hosted at Oracle Headquarters in Reston, VA. This is a format we hope to replicate in different cities across the US and in Europe in the future. We were really excited to have with us Suhas Uliyar, Oracle’s VP of Mobile Strategy and Product Management, and the visionary behind Oracle mobility. I had the honor of introducing him to (more...)
create materialized view apx_application_pages
|Chrome Developer Tools Mobile Emulation|
If you attended my presentation at AUSOUG Perth earlier this month, or if you’ve had a peek at the slides, you may be interested in a more concrete demonstration of the ideas presented. So if you’d like to install and play with a sample application that includes a TAPI generator, feel free to download this.
Disclaimer: this is provided for information (and entertainment) purposes only.
Oracle Application Express 4.2.2 or later