Randy,

SELECT 'set sqlprompt "' || lower(user) || '\' || lower(name) ||'>"'
from v$database

This may work when you connect as system ors sys or any other user who
is having select privilege on V$database. If you want this setting to
work irrespective of the kind of connecting to sql worksheeet.
Try selecting the database name from global_name.

SELECT GLOBAL_NAME FROM GLOBAL_NAME;

Thanks
JAIMURUGAN

-----Original Message-----
From: Netz Randy N
[mailto:oracledba-ezmlmshield-x69547905.[Email address protected]
Sent: Friday, December 31, 2004 12:02 AM
To: LazyDBA Discussion
Subject: RE: Sqlplus Worksheet 9.0

Thanks!



Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)

-----Original Message-----
From: Pieart.Larry
[mailto:oracledba-ezmlmshield-x95885080.[Email address protected]
Sent: Thursday, December 30, 2004 12:26 PM
To: LazyDBA Discussion
Subject: RE: Sqlplus Worksheet 9.0


Usually it's in <$ORACLE_HOME>/sqlplus/admin

It's a file called glogin.sql

We put stuff like this in ours:
SET numwidth 9
SET linesize 200
SET pagesize 66
SET define off
SET serveroutput ON
SET termout off
SET heading off
SET feedback off
spool set_prompt.sql
SELECT 'set sqlprompt "' || lower(user) || '\' || lower(name) ||'>"'
from v$database;
spool off
START set_prompt.sql
SET termout ON
SET heading ON
SET feedback ON


HTH

Larry

-----Original Message-----
From: Netz Randy N
[mailto:oracledba-ezmlmshield-x26070938.[Email address protected]
Sent: Thursday, December 30, 2004 12:21 PM
To: LazyDBA Discussion
Subject: Sqlplus Worksheet 9.0

I have a quick question. I use Sqlplus Worksheet a lot from me desktop.


Everytime I bring this GUI tool up, I have to set the pagesize and
linesize myself.

I know there is a parameter file that I can set these parameters in it
so that they are set when I bring the tool up ... but I cannot locate
it.

Does anyone know where it is, what it's called?



Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Confidentiality Statement:

This message is intended only for the individual or entity to which it is addressed. It may contain privileged, confidential information which is exempt from disclosure under applicable laws. If you are not the intended recipient, please note that you are strictly prohibited from disseminating or distributing this information (other than to the intended recipient) or copying this information. If you have received this communication in error, please notify us immediately by return email.


Oracle LazyDBA home page