Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Blog

Digital Innovation Partner

Fix Broken Permalinks Moving WordPress

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

the Albanian partner of Synaptica

a picture from Tirana, the computer point of Ivano

Oracle Tip – Oracle data files size

Oracle Tip – Set Decimal separator for an oracle session

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 :

in this case the “decimal separator” is the point “.”. if you want the parameter is set inside a procedure or a function you can write like…
Leggi tutto

Oracle Tip – TO_DATE & TO_CHAR

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:

For viceversa To format a string to date you can use TO_ function like this:

The format mask list: Parameter Explanation YEAR Year, spelled out…
Leggi tutto

Oracle Tip – retrive oracle version

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%’;