meyert_at_dataserv.dla-marbach.de (Thomas.Meyer) wrote:
>I would like to have the database/service that I'm connected to displayed in the SQL*PLUS prompt, like having the UNIX host name displayed in, say, the ksh prompt.
- @(#)$Header: /usr/local/cvsroot/gerhard/gerhard/oraconf/login.sql,v
1.4 1997/07/04 15:45:07 gemoe Exp $
- Startup-Skript für Oracle SQL*Plus
- Set the prompt of sqlplus:
- gemoe_at_gerhard:orcl (8) SQL>
- | | | | |
- | | | | String
- | | | Oracle session ID
- | | Oracle database name
- | Machine name
- Oracle user
set termout off
- Machine and database names
column glogin_prompt1 noprint new_value _glogin_prompt1
select
substr(program,instr(program,'@')+1,instr(program,'.')-instr(program,'@')-1)
||
':' || value glogin_prompt1
from v$parameter,v$process where program like '%SMON%' and
name='db_name';
- Session-id
column glogin_prompt3 noprint new_value _glogin_prompt3
select sid glogin_prompt3 from v$session where audsid =
userenv('sessionid');
- Oracle user name
column glogin_prompt4 noprint new_value _glogin_prompt4
select user glogin_prompt4 from dual;
- Building the prompt
column glogin_prompt5 noprint new_value _glogin_prompt5
select ltrim('&_glogin_prompt4') || '@' || '&_glogin_prompt1' ||
' SQL(' || ltrim('&_glogin_prompt3') || ')> ' glogin_prompt5
from dual;
set sqlprompt '&_glogin_prompt5'
set termout on
clear column
- Set viewing of several lines via paging
set pagesize 24 linesize 132 pause on pause 'Hit Enter To Continue...'
- Set the editor to vim
define _EDITOR = vim
define _editor = vim
Received on Mon Oct 06 1997 - 00:00:00 CDT