Tag Archives: Oracle

Oracle VARCHAR2(1) vs CHAR(1)?

Posted on August 17, 2009 by ryelpango

Well, minimum size for both Oracle datatypes is 1 byte. So in terms of storage, they’ll both consume either null or 1 byte in storage space. So, when declaring a character datatype with a length of 1, it doesn’t really … Continue reading →

Posted in CHAR, Datatype, Oracle, VARCHAR2 | Tagged , , | Leave a comment

Improving Performance of Your Oracle Application Express Software

Posted on February 4, 2009 by ryelpango

I am writing this article with the thread http://forums.oracle.com/forums/thread.jspa?messageID=3205216&#3205216 in mind. We have a very large workflow application written in Oracle Application Express, supporting some 3000+ users. This application was written with care, for obvious reasons. Well for one, it’s … Continue reading →

Posted in ApEx, Oracle, PL/SQL | Tagged , , , | 3 Comments

Importing Oracle ApEx 3.1 Page Export into ApEx 3.0 Application

Posted on October 21, 2008 by ryelpango

This is a hack that worked for me on several occasions. Our development environment was upgraded to Oracle ApEx 3.1, but for whatever reason, our production environment was not (it’s still sitting on the previous version ApEx 3.0). Our server … Continue reading →

Posted in ApEx, Oracle | Tagged , , , , | Leave a comment

HTTP Post from Oracle PL/SQL

Posted on October 2, 2008 by ryelpango

I recently needed to execute a HTTP post from an ApEx application to another web page running as some sort of a service. For added security the web page service only accepted POST requests and one of the parameters passed … Continue reading →

Posted in Oracle, PL/SQL | Tagged , , , , | 2 Comments