About: ivan

Recent Posts by ivan

the Albanian partner of Synaptica

a picture from Tirana, the computer point of Ivano

Oracle Tip – Oracle data files size

    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

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

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

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

Recent Comments by ivan

    No comments by ivan yet.