OraNA :: Oracle News Aggregator

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…

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 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 …

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…

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…

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