djmein.blogspot.com
Duncan Mein's Blog: September 2008
http://djmein.blogspot.com/2008_09_01_archive.html
Friday, 26 September 2008. Web Cache Compression and MOD GZIP. Some of my colleagues are working on a project where bandwidth is massively limited (64k). One suggestion to increase application response time was to use MOD GZIP (an open source compressor extension to Apache) to compress the outbound HTTP traffic. The only drawback is that MOD GZIP is not supported by Oracle. Navigating through an application with compression turned on was noticeably quicker than one without compression. Me at Lake Como.
djmein.blogspot.com
Duncan Mein's Blog: August 2009
http://djmein.blogspot.com/2009_08_01_archive.html
Tuesday, 25 August 2009. Generate Days in Month (PIPELINED Functions). This cool example is not one I can take the credit for but since it is used pretty heavily in our organisation, I thought I would share it as it's not only pretty cool buy also demonstrates how useful Oracle Pipelined functions can be. To see this in operation, simply create the following objects:. CREATE OR REPLACE TYPE TABLE OF DATES IS TABLE OF DATE;. CREATE OR REPLACE FUNCTION GET DAYS IN MONTH. Pv start date i IN DATE. I hope som...
djmein.blogspot.com
Duncan Mein's Blog: July 2008
http://djmein.blogspot.com/2008_07_01_archive.html
Thursday, 24 July 2008. Reset the APEX internal password. I noticed in one of the comments of Dimitri Gielis articles. Pointed out a script called apxXEpwd.sql. I ran this as the SYS user and sure enough, it allows you to reset the ADMIN password for the internal workspace. This script can be found in the root apex directory that you download from OTN. Very useful when you forget what that password is! Monday, 14 July 2008. Import APEX application via SQL Developer. Download SQL Developer from: OTN.
djmein.blogspot.com
Duncan Mein's Blog: Oracle, APEX and Longevity!
http://djmein.blogspot.com/2012/04/oracle-apex-and-longevity.html
Friday, 20 April 2012. Oracle, APEX and Longevity! I have just read the latest Statement of Direction from Oracle ( download here. And there are some comforting statements from Oracle about there long term commitment to Application Express. For those like me who have been using APEX since the early days, this is good news as it represents a very clear intent that Oracle are very serious about APEX as key development framework. Subscribe to: Post Comments (Atom). Me at Lake Como. Application Express on OTN.
djmein.blogspot.com
Duncan Mein's Blog: February 2010
http://djmein.blogspot.com/2010_02_01_archive.html
Tuesday, 23 February 2010. APEX - Identify Report Columns Vulnerable to XSS. The following query is a very simple way of identifying all report columns within your APEX application that may be exposed by Cross Site Scripting (XSS). XSS allows an attacker to inject web script (JavaScript) into an application and when this is rendered in the report, the script is interpreted rather than rendered as text. SELECT application id,. FROM apex application page rpt cols. WHERE display as NOT IN. ORDER BY 1, 2, 3;.
djmein.blogspot.com
Duncan Mein's Blog: November 2010
http://djmein.blogspot.com/2010_11_01_archive.html
Wednesday, 3 November 2010. Beware of the Byte. Recently our test department raised a bug against one our applications that occurred when trying to insert a record into a table. The error message encountered was a fairly innocuous " ORA-01704: string literal too long. 8221; value of 10, the text area had been created with a “ Character Counter. 8221; Strange then how a form item accepting 10 characters was erroring whilst inserting into a column of VARCHAR2(10). WHERE parameter = 'NLS CHARACTERSET';.
djmein.blogspot.com
Duncan Mein's Blog: Oracle VirtualBox... a good thing.
http://djmein.blogspot.com/2012/06/oracle-virtualbox-good-thing.html
Sunday, 17 June 2012. Oracle VirtualBox. a good thing. Now as anyone who knows me me will confirm, I have always been a long admirer of VMWare and their suite of excellent virtualisation products. I started with Workstation before switching to Fusion on OS X and finally made the jump to the way cool ESXi a few years back (I blogged about this here. Just a quick clarification. The oracle-validated package (OL5) and the oracle-rdbms-server-11gR2-preinstall (OL6) are available from public-yum.oracle...One o...
djmein.blogspot.com
Duncan Mein's Blog: Clear Cache for all Pages within a Page Group
http://djmein.blogspot.com/2012/06/clear-cache-for-all-pages-within-page.html
Wednesday, 20 June 2012. Clear Cache for all Pages within a Page Group. Most client sites I have been on tend to love wizards that hold the users hand through often complex business process / workflows. Not a problem. This can be achieved very simply by using an Application Item, A Single Application Process and Page Groups. Here is how:. 1 Create a Page Group with a name the logically describes the functional area it servers. In this example I will use the name: " CREDIT CARD APPLICATION. It then uses t...
djmein.blogspot.com
Duncan Mein's Blog: June 2008
http://djmein.blogspot.com/2008_06_01_archive.html
Tuesday, 10 June 2008. APEX 3.1.1 Released. Just upgraded from APEX 3.1 to 3.1.1 on an Oracle Enterpise Linux 4 Update 4 platform. Intall took: 5:39 and termintaed without error. The patch can be downloaded from metalink. All in all, a very simple upgrade and now onto the task of regression testing our current 3.1 apps. Subscribe to: Posts (Atom). Me at Lake Como. Application Express on OTN. There was an error in this gadget. View my complete profile. APEX 3.1.1 Released.
djmein.blogspot.com
Duncan Mein's Blog: March 2009
http://djmein.blogspot.com/2009_03_01_archive.html
Sunday, 29 March 2009. Sum to Parent Nodes in Hierarchy Queries: CONNECT BY ROOT. In one of our Applicaitons, the table DEPT contains a self referncing join (Pigs Ear) as it models our organsational department hierarchy. DEPT ID NUMBER NOT NULL. DEPT NAME VARCHAR2 (100) NOT NULL. EMPLOYEES NUMBER NOT NULL. CONSTRAINT DEPT PK PRIMARY KEY (DEPT ID). CONSTRAINT DEPT FK01 FOREIGN KEY (PARENT ID). REFERENCES DEPT (DEPT ID). INSERT INTO DEPT VALUES (1,NULL,'IT', 100);. INSERT INTO DEPT VALUES (4,1,'TEST', 25);.