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 :
|
1 |
ALTER SESSION SET NLS_NUMERIC_CHARACTERS ='. '; |
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
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:
|
1 |
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:
|
1 |
SELECT TO_DATE('2003/07/09', 'yyyy/mm/dd') from dual; |
The format mask list: Parameter Explanation YEAR Year, spelled out…
Leggi tutto
Using JDBC with Oracle 10g i found this error : “ora 12519 tnsno appropriate service handler found”, today i found an article on Internet about. I only execute on apex query :
|
1 |
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE; |
after that i restarted my Oracle10gXe server on my server, and all works well !!! incredible
I just starting on using Oracle 10g …. how to 1 : how retrive a guid from Oracle
|
1 |
select sys_guid() from dual; |
how to 2 : how retrive next value from a Sequence
|
1 |
select [your sequence name].nextval into from dual ; |
how to 3 : Oracle db Link , how to manage sql between multiple schema … With DB Link you can produce sql /…
Leggi tutto
