Re: Changing the command prompt to the User Name

From: Daniel B. Bikle <dbikle_at_cco.caltech.edu>
Date: 21 Aug 1993 18:26:26 GMT
Message-ID: <255pciINN80u_at_gap.caltech.edu>

mcconnel_at_source.asset.com (Andrew McConnell) writes:

>I am trying to change the command prompt in SQL*Plus so that rather
>than the standard 'SQL>' , the prompt will be
 

>'scott >>'

Folks,

try putting this in your login.sql:

rem change prompt to 'user sql> '

set termout off
col x new_value y
select max(user) x from dual;
set sqlprompt '&y sql> '
set termout on

rem the end

---

Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542

---

Received on Sat Aug 21 1993 - 20:26:26 CEST