SQLPLUS prompt

I got my PC refreshed the other day. Lost most of my settings and didn't have a good backup though have been backup up files here and there, throwing here..form disk A to disk B...at the end when disaster strike...can't really manage to handle.

Anyway, visit http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-06-22.9332221251

It has a good write up on SQLPLus prompt customization.

My sample and favorite as below

COLUMN file_name FORMAT a44
COLUMN tablespace_name FORMAT a20
COLUMN owner FORMAT a15
COLUMN segment_name FORMAT a20
set lines 132
set pages 100
set termout off
col dbname new_value prompt_dbname
col uname new_value prompt_username

select instance_name dbname from v$instance;
select user uname from dual;
set sqlprompt "&&prompt_username'@'&&prompt_dbname> "
set termout on
set time off