Re: UNIX-like prompt in SQL*PLUS

This is a multi-part message in MIME format.
--------------8E5B8B9884008F0EF85FE431

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

how about trying this:
column ROWLABEL format A15
column LINE/COL format A8
column ERROR format A65 WORD_WRAPPED set termout off
define new_prompt='nolog'
column XX new_value new_prompt
select
lower(username)||'@'||substr(lower(global_name),1,instr(global_name,'.')X

    from global_name, user_users;
set sqlprompt "&new_prompt> "
set termout on

--
Joseph S. Testa, Oracle Database Administrator
Are you looking for Oracle DBA in Central Ohio, but only want one for
some part-time work? try http://web.scioto.net/jtesta
That is also the place to find the FREE, "how do I build a second,
third, etc, instance, without using oracle's installer, database
scripts.
ICQ UIN: 2814105




--------------8E5B8B9884008F0EF85FE431

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Joseph S. Testa
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Joseph S. Testa
n:              Testa;Joseph S.
org:            Origin Technology in Business
adr:            ;;;;OH;;USA
email;internet: jtesta_at_scioto.net
title:          Oracle DBA
note:           Oracle DBA in central Ohio and doing geneaology research on Testa family, I have 2 ICQ uins, home: 2814105, work 2832230, you can also find me on netscape conference.
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard




--------------8E5B8B9884008F0EF85FE431--