simonhunt.blogspot.com
SHUNT'S Blog: Way to go Oracle
http://simonhunt.blogspot.com/2014/03/way-to-go-oracle.html
Mostly ORACLE APEX and Windsurfing stuff. Monday, 24 March 2014. Way to go Oracle. Just bought my self a new dev box, an Intel NUC with beautiful 29" LG ultra wide ;) and decided to install Windows after years of Mac and Linux. I have to say awesome! And it's a whole lot cheaper). Hooray, success this worked https:/ community.oracle.com/message/11308596#11308596. Subscribe to: Post Comments (Atom). Hill Head, UK 2006. A bad day on the water is better than a good day in the office! View my complete profile.
dpeake.blogspot.com
David Peake on Oracle APEX: APEX 4.2.1 Patch Set Released
http://dpeake.blogspot.com/2012/12/apex-421-patch-set-released.html
David Peake on Oracle APEX. Product Manager for Oracle Application Express (APEX), formerly HTML-DB. Friday, December 14, 2012. APEX 4.2.1 Patch Set Released. Today we released APEX 4.2.1 on the APEX OTN Download. This is a cumulative patch set for APEX 4.2.0. There were quite a number of APEX 4.2.0 Known Issues. The majority of which have been incorporated into APEX 4.2.1. It is important to read the APEX 4.2.1 Patch Set Notes. And also the APEX 4.2 Release Notes. When installing APEX 4.2.1. One of the ...
oracle-wtf.blogspot.com
Oracle WTF: Looping the hard way
http://oracle-wtf.blogspot.com/2014/01/looping-hard-way.html
Sunday, January 05, 2014. Looping the hard way. The task was to construct partition names from 'P001' to (for some reason) 'P336', as part of a larger maintenance script. Here's what they came up with:. Declare p varchar2(4); i number := 1; begin loop if i. 336; dbms output.put line(p); end loop; end;. Posted by William Robertson. You expect DBAs to be conversant in using LPAD? January 27, 2014 12:39 pm. Subscribe to: Post Comments (Atom). Mail us your WTFs. Google definitions for "WTF".
simonhunt.blogspot.com
SHUNT'S Blog: November 2009
http://simonhunt.blogspot.com/2009_11_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Saturday, 28 November 2009. Convert a colon separated function into a table. The is a useful function that converts the output from the page items below into a table, so that you can manipulate the data using SQL. CREATE OR REPLACE PACKAGE useful functions IS. Purpose : Lots of useful function and procedures. TYPE ret val t IS TABLE OF VARCHAR(4000);. Public function and procedure declarations. FUNCTION checkbox table(p checkbox VARCHAR2) RETURN ret val t. It is ...
simonhunt.blogspot.com
SHUNT'S Blog: March 2014
http://simonhunt.blogspot.com/2014_03_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Monday, 24 March 2014. Way to go Oracle. Just bought my self a new dev box, an Intel NUC with beautiful 29" LG ultra wide ;) and decided to install Windows after years of Mac and Linux. I have to say awesome! And it's a whole lot cheaper). Hooray, success this worked https:/ community.oracle.com/message/11308596#11308596. Subscribe to: Posts (Atom). Hill Head, UK 2006. A bad day on the water is better than a good day in the office! View my complete profile.
simonhunt.blogspot.com
SHUNT'S Blog: January 2009
http://simonhunt.blogspot.com/2009_01_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Monday, 19 January 2009. Hiding Columns In Interactive Reports. This problem has been bugging me for ages, how to hide columns when downloading with interactive reports. The answer is simple; for the column you wish to hide set the Conditional Display as follows:. Condition Type: Request Is NOT Contained within Expression 1. Expression1: CSV,PDF,RTF,XLS. Subscribe to: Posts (Atom). Hill Head, UK 2006. A bad day on the water is better than a good day in the office!
simonhunt.blogspot.com
SHUNT'S Blog: October 2011
http://simonhunt.blogspot.com/2011_10_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Thursday, 27 October 2011. Reformat NULL fields in a report. Add the following to the 'Execute when Page Loads' region of the Page (where the column name is JACK):. Apex Shuttle Extender Key LOV. 1 Create a Shuttle Item P44 SHUTTLE with a basic set of values e.g. SELECT ename, empno FROM emp WHERE empno 7782. However the extended shuttle menu will inevitably contain values that are not in the basic lov. Using the Display Additional Values, will only display t...
simonhunt.blogspot.com
SHUNT'S Blog: July 2012
http://simonhunt.blogspot.com/2012_07_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Tuesday, 24 July 2012. Apex Item Select List Alternative. Http:/ apex.oracle.com/pls/apex/f? This uses the standard APEX ITEM.SELECT LIST FROM LOV(1,null,'RESULT') to generate the Select Lists. As you can see from the footer the region takes around 0.6 seconds for a dataset of 60 rows and 12 columns. Scale this up a bit and it takes significantly longer. Http:/ apex.oracle.com/pls/apex/f? Function and Global Variable Declaration:. GThis = pThis;. Tr td onmouseove...
simonhunt.blogspot.com
SHUNT'S Blog: Disable Shuttle Item Values
http://simonhunt.blogspot.com/2012/11/disable-shuttle-item-values.html
Mostly ORACLE APEX and Windsurfing stuff. Thursday, 8 November 2012. Disable Shuttle Item Values. Http:/ apex.oracle.com/pls/apex/f? Function and Global Variable Declaration. Function shuttleMove(pMove1,pMove2) {. P60 SHUTTLE " pMove2 " option").each(function () {. This)appendTo('#P60 SHUTTLE ' pMove1);. Execute when Page Loads. Var valDis = ':' $v(P60 HIDDEN) ':';. P60 SHUTTLE option").each(function () {. Var valThis = ':' $(this).val() ':';. If (valDis.indexOf(valThis) -1) {. Hill Head, UK 2006.
simonhunt.blogspot.com
SHUNT'S Blog: April 2014
http://simonhunt.blogspot.com/2014_04_01_archive.html
Mostly ORACLE APEX and Windsurfing stuff. Tuesday, 22 April 2014. Clear apex item.popupkey from query. The apex item.popupkey from query does not include a show null function that allows users to select a null. Value The following add a clear function to the popup lov. PThisprev('span').find('input').each(function() {. Column Formatting - HTML Expression:. Span style="white-space:nowrap;" #COLUMN NAME#. Span onClick="fClear($(this) ;". Img src="#IMAGE PREFIX#delete.gif" alt="Clear" /. Hill Head, UK 2006.
SOCIAL ENGAGEMENT