Can I run host command in select from dual?

[kris109]

In 8i, you can use DBMS_SESSION.set_context to create a context and you can use:

SELECT SYS_CONTEXT (’USERENV’, ’HOST’) FROM DUAL;

to get the host name.