Hi All,
I'm trying to get the hostname of the machine for non-dba users and place this in the SQL prompt. Here is the script.

--Place USERNAME@HOSTNAME on prompt
column user new_value ouser noprint;
column system new_value osystem noprint;
select user from dual;

--next line does not work
select 'host hostname' system from dual;

--desired outputset sql
set sqlprompt '[&ouser@&osystem]SQL>';

What am I doing wrong?