Hi, to open the window I use this: set NLS_LANG=GERMAN_GERMANY.US8PC437set NLS_DATE_FORMAT=dd.mm.yyyy hh24:mi:ssC:\oracle\product\11.2.0\client_1\bin\sqlpl us /nologAnd then the glogin.sql: set pagesize 50set linesize 200set trimspool onset serveroutput on size 1000000 format wrappedset long 20000set feedback 1set timing onset sqlprompt "&&_USER@&&_CONNECT_IDENTIFIER> "select instance_name, host_name, status, startup_time from v$instance; Regards Ingrid Gesendet: Dienstag, 05. März 2013 um 13:08 Uhr Von: "Lukas Lehner"<weblehner@xxxxxxxxx> An: Oracle-L@xxxxxxxxxxxxx Betreff: please post your login.sql / glogin.sql [EXAMPLES] Hi please post your login.sql / glogin.sql I need some examples for my environment. Lukas -- //www.freelists.org/webpage/oracle-l[1] --- Links --- 1 //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l