SQL*Plus (MOSC)

MOSC Banner

Windows env.. Howmake login.sql work

in SQL*Plus (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center