-
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?
ora_newbie@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|