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 procedure or a…
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: 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’) from dual; The…
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 : 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 select sys_guid() from dual; how to 2 : how retrive next value from a Sequence select [your sequence name].nextval into from dual ; how to 3 : Oracle db Link , how to manage sql between multiple…
Leggi tutto
