Oracle - apply case insensitive and date format

[Costas]

you can see the current settings via :

SELECT *
  FROM NLS_SESSION_PARAMETERS
  WHERE PARAMETER IN ('NLS_COMP', 'NLS_SORT', 'NLS_DATE_FORMAT');

method 1 - alter by session

  alter session set nls_sort=BINARY_CI;
  alter session set nls_comp=LINGUISTIC;
  alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';

method 2 - permanent fix via IDE