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
Previous Topic: Urgent! Select to file
Next Topic: date format in SQL query
Goto Forum:
  


Current Time: Mon Dec 23 05:51:16 CST 2024