Friday, 26 October 2012
http://www.apexblogs.info was a place I visited daily. A couple of days ago this domain was moved to http://www.odtug.com/apex. I am not sure I understand why but it doesn't matter. The only thing is that from the usability perspective this is now at least two steps back.
Sunday, 14 October 2012
This function may help you if you need to report on columns with a lot of text. It will get rid of the carriage return and will help not to break your reports imported into Excel:
CREATE OR REPLACE FUNCTION x_rep (p_string IN VARCHAR2) RETURN VARCHAR2 IS v_string VARCHAR2 (4000); BEGIN v_string := REPLACE (TRANSLATE (p_string, 'x' || CHR (10) || CHR (13), 'x'), ';', '/' ); RETURN v_string; EXCEPTION WHEN OTHERS THEN RETURN NULL; END x_rep; /
Monday, 1 October 2012
The link to My Demo Application on apex.oracle.com has been changed from http://apex.oracle.com/pls/otn/f?p=31517:1 to https://apex.oracle.com/pls/apex/f?p=31517:1 While trying to open the old link you will receive a funny message: