OraNA :: Oracle News Aggregator

It’s been over two years since I released the initial version of the jQGrid Integration Kit for PL/SQL and Apex.Since then, I’ve added some additional features and fixed a few bugs:Version 1.1Procedure include_static_files_once will make sure required …

This time I will present a solution for a character validation on the APEX item level.Normally you create a simple validation based on a REGULAR EXPRESSIONS which checks for a set of characters which are allowed inside your item. If there are characte…

For sometime Kris Rice and I have talked about wanting to do a "Soup-to-Nuts" series of labs. With many thanks to Marcie Young from Curriculum Development, such a series now exists on the Oracle Learning Library (OLL) : http://apex.oracle.co…

If for any reason you have a two databases running on the same server and one of them is Oracle 11g Express Edition then you will get surprised that listener of XE is not started automatically during boot if there is another listener already running. D…

On May 12 iAdvise hosted the “APEX and mobile seminar”.
With a turnout of more than 50 customers and interested developers, it indicates that mobile development is a real hype and the demand for mobile applications is rising.
This was the starting …

I’m currently working on a integration of the jQuery Real Person (Captcha) plugin into APEX.On the server side I had to execute a shift left. Which normally works like this:5381<< 5With Oracle SQL you can do like this: select 5381*power(2,5) from…

/* 1. Standard sub query */ UPDATE tbl_employees x   SET department = (       SELECT y.name         FROM tbl_department y        WHERE y.dept_id = x.dept_id);/* 2. Sub query with exist clause */UPDATE tbl_employees x   SET depa…

I’m an huge NGINX fan. Nginx pronounced “Engine-X” is an open source Web server and a reverse proxy server for HTTP, SMTP, POP3 and IMAP protocols, with a strong focus on high concurrency, performance and low memory usage. Nginx is awesome… re…

You might be wondering what is going on behind the scenes.
We’ve previously talked a little about our joint venture and what we are planning to do,and now you are probably wondering when it all begins?

Truth is, all of us are working really hard to …

Joel Kallman has an interesting and amusing reaction to a recent Gartner paper authored by Mark Driver posted here.  After reading Joel’s reply and Mark’s paper, it got me thinking a bit about what was both in and not in the Gartner review and conclus…

I really like the Label Cloud Plugin by Carsten Czarski but a customer complained that there are not so much visual differences by words when the occurences are very similar.For example you have 20 words inside your cloud:10 words with a value of 104 …

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.Rather than ignore a potentially damaging report about Oracle Application Express and hope no one notices it, I wish to expose it to the light of day.I read …

As soon as I posted this entry yesterday, I thought of a few additional “rules” that probably should have been included.  Pitor’s comment also spurred on an additional rule.  So without further adieu, here they are:StandardsLearn ‘em and stick to ‘em…

This is an example for the use of a simple cookie which gets created after submit when click on a button. Afterwards a region inside my page shouldn’t be shown anymore. The cookie itself is valid for 30 days and will save the value “1″.Page process:be…

There’s something to be said for corporate standards for browsers. Sure, it’s almost always some flavor of IE, but at least you’re only charged with making sure that your application runs and looks good on one browser on a single OS. However, when de…

If you want to beautify your number column inside an APEX report with a percent-sign then most of you would do like this:  select column_name || ‘%’ as column_namefrom my_tableThis creates the correct output but the sort will not work anymore as expe…

In unserem aktuellen Tipp stellen wir Ihnen das mit APEX 4.1 neu eingeführte
Feature "Data Upload" für den Endanwender vor. Während der APEX-Entwickler
kommaseparierte Dateien schon seit
HTML…

Less then one week is left and only 4 plugins has made there way to the competition:http://www.apex-plugin.com/oracle-apex-plugins/odtug-competition.htmlThat is your chance to take the opportunity and win the challenge.Good luck. Tobias