Monthly Archives: November 2013

Fix Broken Permalinks Moving WordPress

Written on November 29, 2013 at 13:09, by

Very good!
http://jeffsebring.com/2010/fixing-broken-permalinks-when-moving-wordpress/

Fix Broken Permalinks Moving WordPress

Written on November 29, 2013 at 13:09, by

Very good!
http://jeffsebring.com/2010/fixing-broken-permalinks-when-moving-wordpress/

the Albanian partner of Synaptica

Written on November 13, 2013 at 12:04, by

a picture from Tirana, the computer point of Ivano

Oracle Tip – Oracle data files size

Written on November 6, 2013 at 17:03, by

    SELECT *  FROM dba_data_files;         SELECT sum(bytes / (1024*1024)) “DB Size in MB” FROM dba_data_files;      

Oracle Tip – Set Decimal separator for an oracle session

Written on November 6, 2013 at 15:03, by

To set in a single session the decimal separator, for example when you need to cast some string in numbers you can use the next istruction :     ALTER SESSION SET NLS_NUMERIC_CHARACTERS =‘. ‘;   in this case the “decimal separator” is the point “.”. if you want the parameter is set inside a […]

Oracle Tip – TO_DATE & TO_CHAR

Written on November 6, 2013 at 14:53, by

In Oracle there are two usefull function to format a timestamp to string and vceversa…. To format a date to string you can use TO_CHAR function like this:   SELECT TO_CHAR(sysdate, ‘DD-MON-YYYY HH24:MI:SSxFF’) FROM dual;   For viceversa To format a string to date you can use TO_ function like this:   SELECT TO_DATE(’2003/07/09′, ‘yyyy/mm/dd’) […]

Oracle Tip – retrive oracle version

Written on November 4, 2013 at 13:17, by

Per ottenere le informazioni di versione da una console Oracle o da plsql è sufficiente utilizzare il seguente predicato select * from v$version where banner like ‘Oracle%’;

Spettacolo linkify Android SDK

Written on November 1, 2013 at 22:54, by

http://android-developers.blogspot.it/2008/03/linkify-your-text.html