Thursday, 8 January 2015

Using a pipelined function with parameters in a view

›
In the Oracle database you can use pipelined functions to improve performance or decrease complexity. With the table function a pipelined fu...
3 comments:
Friday, 18 July 2014

Avoiding ORA-04068

›
This is a nasty error that can occur when a package is recompiled during an Oracle session. I work now in an environment where this occasion...
Monday, 24 March 2014

The advantage of fonts over images

›
--> Imagine your boss wants you to create an application with iconic buttons, He has an image that is to be used for menu buttons, a...
Tuesday, 18 February 2014

Splitting an Apex report into several columns

›
The other day I was asked to create a page where a large number of properties should be connected to an object. I created a report consistin...
5 comments:
Wednesday, 16 October 2013

Removing old public Interactive Reports

›
By saving public Apex Interactive Reports you can offer various custom reports to users without programming. The user opens the page and can...
4 comments:
Monday, 2 September 2013

Automatically generating images for styles

›
Lately I have been developing a kind of SaaS website with Apex. Several companies were to be represented in this website and each company wa...
Friday, 20 April 2012

Weekday Numbers in Apex sensitive to Application Primary Language

›
The weekday in Apex is dependent on of the language set in the Application Properties. For that you cannot rely on TO_CHAR( datevalue ,’d’) ...
1 comment: