This content has been marked as final. Show 2 replies
Can i somehow specify more than one statement in new-connection-sql?
ALTER SESSION SET NLS_DATE_FORMAT='dd/mm/yyyy hh24:mi:ss'
ALTER SESSION SET NLS_DATE_LANGUAGE='Ukrainian'
No it will not work .
anyway i found how to do that: look at this code:
Begin execute immediate('ALTER SESSION SET NLS_DATE_FORMAT=''dd/mm/yyyy hh24:mi:ss'''); execute immediate('ALTER SESSION SET NLS_DATE_LANGUAGE=''Ukrainian'''); end;