SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual

SELECT SYS_CONTEXT('USERENV','CURRENT_SCHEMA') FROM dual