Windows env.. Howmake login.sql work
environment is sqlplus with oracle 21c/19c client under Windows 10.
SQLPATH/ORACLE_PATH pointing to same directory where a login.sql resides.
SET FEEDBACK OFF
SET TERMOUT OFF
COLUMN X NEW_VALUE Y
SELECT LOWER(USER || '@' ||
SYS_CONTEXT('userenv', 'SERVER_HOST') || ':' ||
SYS_CONTEXT('userenv', 'instance_name')) X
FROM dual;
SET SQLPROMPT '&Y
Cannot get this to work.
In unix/linux presents No problem.... What am I missing in wndows