Skip to content

Instantly share code, notes, and snippets.

@fabriciocolombo
Created October 23, 2013 16:28
Show Gist options
  • Save fabriciocolombo/7121890 to your computer and use it in GitHub Desktop.
Save fabriciocolombo/7121890 to your computer and use it in GitHub Desktop.
Trigger de Logon Oracle
CREATE OR REPLACE TRIGGER "LOGON_ON"
AFTER
LOGON
ON SCHEMA
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT="MM/DD/YYYY"';
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_NUMERIC_CHARACTERS=".,"';
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIMESTAMP_FORMAT="MM/DD/YYYY HH24:MI:SSXFF"';
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT="MM/DD/YYYY HH24:MI:SSXFF TZR"';
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment