Home » RDBMS Server » Server Administration » Re: Setting the SQL Prompt to show up the host name
Re: Setting the SQL Prompt to show up the host name [message #373058] Sat, 24 March 2001 08:52
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hi,

u can also try this

set termout off
col user_name new_value user_name
select user user_name from dual;
col dbase_name new_value dbase_name
select substr(global_name,1,instr(global_name,'.')) dbase_name from
global_name;
set sqlprompt "&dbase_name&user_name>";

Cheers,
BAlu

Report message to a moderator

Previous Topic: Urgent! Select to file
Next Topic: date format in SQL query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 11 06:09:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.