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?