Rubrika: Oracle

  select TRUNC(SYSDATE – INTERVAL ‚1‘ YEAR,’YEAR‘) from dual;–01.01.18   select TRUNC(SYSDATE,’YEAR‘) – 1 from dual;–31.12.18

  UPDATE table_1SET col_1= REPLACE(col_1, AAA, zzz)WHERE col_1 like ‚AAA%‘  

ALTER SESSION SET NLS_DATE_FORMAT = ‚DD.MM.YYYY HH24:MI:SS“

  ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ‚. ‚