CODE EXAMPLE FOR SQL

alter session set nls_language french

-- Language
ALTER SESSION SET NLS_LANGUAGE='FRENCH';
-- Date format for session
ALTER SESSION SET NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';