Re: August PL/SQL Tip of the Month: SQL*Plus Prompt Change
Date: Wed, 18 Aug 1999 12:39:57 -0500
Message-ID: <NfCu3.494$tZ.34954_at_news1.primary.net>
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
FYI,
I had to do a
grant select_catalog_role to user
from SYS to get this to work.
campbell_white_at_my-deja.com wrote in message =
<7p95jk$40r$1_at_nnrp1.deja.com>...
>August's Tip of the Month
>
>A common request in the world of SQL*Plus is to change the prompt to
>reflect information about the environment, such as the Oracle instance.
>Mike Ault, RevealNet Oracle Administration Knowledge Base author,
>offers this code to accomplish the prompt change:
>
>column xdb_name new_value xdb noprint;
>select name||': ' xdb_name from v$database;
>set sqlprompt &xdb
>
>You can put these three lines inside your glogin.sql or login.sql
>scripts so that the prompt is set when you start up SQL*Plus (note that
>when you CONNECT from within SQL*Plus to another schema you will have
>to run one of these files manually to reset the prompt).
>
>So there's one example of a SQL*Plus prompt change. Please visit the
>"PL/SQL Pipeline" http://ww.revealnet.com/plsql-pipeline.htm if you
>have any other useful prompt settings that you would like to share. If
>so, please go to Pipetalk and add your entry in the new FAQ conference
>under the "Modifying the SQL*Plus prompt" posting.
>
>Thanks, Steven Feuerstein
>--------------------------------------------------
>RevealNet Oracle Development News
>- PL/Formatter for Quest Software's TOAD Now Available
>- PCWEEK LABS Gives PL/Generator a Strong Review
>- PL/Vision Now Integrated With Quest Software's SQL Navigator
>Full Information at http://www.revealnet.com
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
------=_NextPart_000_0086_01BEE976.C93EA050
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dwindows-1252" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR></HEAD> <BODY> <DIV>FYI,</DIV> <DIV>I had to do a</DIV> <DIV><FONT color=3D#ff0000>grant select_catalog_role to = <EM>user</EM></FONT></DIV> [Quoted] <DIV>from SYS to get this to work.</DIV> <DIV> </DIV> <DIV><A =
href=3D"mailto:campbell_white_at_my-deja.com">campbell_white_at_my-deja.com</A>= =20
<CAMPBELL_WHITE_at_MY-DEJA.COM>wrote in message <<A=20 href=3D"mailto:7p95jk$40r$1_at_nnrp1.deja.com">7p95jk$40r$1_at_nnrp1.deja.com</= A>>...</DIV>>August's=20
Tip of the Month<BR>><BR>>A common request in the world of = SQL*Plus is to=20
change the prompt to<BR>>reflect information about the environment, = such as=20
the Oracle instance.<BR>>Mike Ault, RevealNet Oracle Administration = Knowledge=20
Base author,<BR>>offers this code to accomplish the prompt=20 change:<BR>><BR>>column xdb_name new_value xdb = noprint;<BR>>select=20
name||': ' xdb_name from v$database;<BR>>set sqlprompt=20 &xdb<BR>><BR>>You can put these three lines inside your = glogin.sql or=20
login.sql<BR>>scripts so that the prompt is set when you start up = SQL*Plus=20
(note that<BR>>when you CONNECT from within SQL*Plus to another = schema you=20
will have<BR>>to run one of these files manually to reset the=20 prompt).<BR>><BR>>So there's one example of a SQL*Plus prompt = change.=20
Please visit the<BR>>"PL/SQL Pipeline" <A=20 href=3D"http://ww.revealnet.com/plsql-pipeline.htm">http://ww.revealnet.c= om/plsql-pipeline.htm</A>=20
if you<BR>>have any other useful prompt settings that you would like = to=20
share. If<BR>>so, please go to Pipetalk and add your entry in the new = FAQ=20
conference<BR>>under the "Modifying the SQL*Plus prompt"=20 posting.<BR>><BR>>Thanks, Steven=20
Feuerstein<BR>>--------------------------------------------------<BR>&=gt;RevealNet=20
Oracle Development News<BR>>- PL/Formatter for Quest Software's TOAD = Now=20
Available<BR>>- PCWEEK LABS Gives PL/Generator a Strong = Review<BR>>-=20
PL/Vision Now Integrated With Quest Software's SQL Navigator<BR>>Full =
Information at <A=20
href=3D"http://www.revealnet.com">http://www.revealnet.com</A><BR>><BR=
>><BR>><BR>>Sent=20
via Deja.com <A=20
href=3D"http://www.deja.com/">http://www.deja.com/</A><BR>>Share what =
you know.=20
Learn what you don't.</BODY></HTML>
------=_NextPart_000_0086_01BEE976.C93EA050-- Received on Wed Aug 18 1999 - 19:39:57 CEST