Try this one.
set serveroutput on size 100
set trimspool on
set long 5000
set linesize 100
set pagesize
column plan_plus_exp format a80
column global_name new_value gname
set termout off
select lower(user) || '@' ||
decode(global_name, 'ORACLE8.WORLD', '8.0', 'ORA8I.WORLD',
'8i',
nombre de Kevin Lange
Enviado el: Thursday, 25 October, 2001 11:10 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Instance Name in Sql Prompt
Ramon;
In your startup directory on SQL Plus, you can automatically run a
script that will setup the environment like
: Multiple recipients of list ORACLE-L
Asunto: RE: Instance Name in Sql Prompt
Ramon;
In your startup directory on SQL Plus, you can automatically run a script
that will setup the environment like you want it. Its called LOGIN.SQL.
Here is a copy of mine:
set termout on
set pagesize 0
set echo
October, 2001 2:35 AM
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Instance Name in Sql Prompt
Hi,
To overcome the connect within a session not changing the prompt a created
a script (connect.sql) and put it in the directory from SQL_PATH registry
entry. When I want to change
I got
this from someone on the list. It shows server, instance and
username. Put it in your login.sql
set
sqlprompt 'SQL '
column
SQLQueryDatabase new_value SQLPromptDatabase
noprintcolumn SQLQueryTablespace new_value SQLPromptTablespace
noprintcolumn SQLQueryUsername new_value
Hi
Add following to your GLOGIN.SQL
*
rem Display the DB SID and username in the Sql*Plus prompt
column dbsid new_value dbsid noprint
select name dbsid from v$database;
column dbusr new_value dbusr noprint
select user
Add the
following to your login.sql or glogin.sql file:
set serveroutput on
set termout off
column instance new_value prompt_instance
select substr(instance_name, 1, 10)instance
from v$instance
/
set sqlprompt prompt_instance
set termout on
HTH,
david
David B.
Hi Ramon,
You could put this into your login.sql script if you have one. This will
automatically take your login name and database and set your sqlprompt
accordingly.
col user_name new_value user_name
col db_name new_value db_name
select lower(user) user_name,
Ramon;
In your startup directory on SQL Plus, you can automatically run a script that
will setup the environment like you want it. Its called
LOGIN.SQL.
Here
is a copy of mine:
set
termout onset pagesize 0set echo offset feedback offset
sqlprompt ''spool c:\temp.sqlselect 'set
Put something like this in your glogin.sql or run it after you log in.
set head off
set termout off
column nombre new_v nombre_basedatos
select name nombre FROM V$DATABASE
/
set sqlprompt 'nombre_basedatos '
set head on
set termout on
, October 25,
2001 10:22 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: Instance Name in Sql
Prompt
Add
the following to your login.sql or glogin.sql
file:
set
serveroutput on
set termout
off
column
instance new_value prompt_instance
select
substr
Thanks it was great
Roland
IT - Database (Do Not Use) [EMAIL PROTECTED]@fatcity.com den
2001-10-25 07:15 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
I got this from someone on the list. It shows
:
Thursday, 25 October, 2001 11:10 AMPara: Multiple recipients of
list ORACLE-LAsunto: RE: Instance Name in Sql
Prompt
Ramon;
In your startup directory on SQL Plus, you can automatically run
a script that will setup the environment like you want it. Its called
LOGIN.SQL.
Here
ORACLE-LAsunto: RE: Instance Name in Sql
Prompt
Add
the following to your login.sql or glogin.sql
file:
set
serveroutput on
set termout
off
column
instance new_value prompt_instance
select
substr(instance_name, 1, 10)instance
from
v$instance
/
set
14 matches
Mail list logo