select SYS_CONTEXT ( 'USERENV', 'TERMINAL', 20 ) from dual;
when run from my machine
sqlplus returns my machine name,
TOAD returns my machine name
sql developer returns "unknown"
sql developer version 18
Tried on database versions 12.1.0.2 and 12.2
Theres a known bug with connecting to DB in non interactive mode, but thats in SQL and also Im not using SYS, application users only but Im thinking SQL developer must be doing something not to pass it in.
 | |
Can someone test their current version and see what they get, we have audit triggers on some tables that are missing data due to this as we have some updates from guys using sql developer and we need that terminal info in.