-
Mr. rohitsn
Let me know more abaut this prompt
tkyte@THINK1.US.ORACLE.COM>
Who do you configuew this prompt and if i do another connection wiht other user and database the prompt change
for the new user connected e new database???
-
You could add in the glogin file in $ORACLE_HOME/sqlplus/admin something like this:
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
select lower(user) || '@' || decode(instr(global_name,'.',1),0,global_name,
substr(global_name,1,instr(global_name,'.',1)-1)) global_name from global_name;
set sqlprompt '&gname> '
set termout on
This will work the first time you connect to sqlplus
Cheers
Angel
-
Dear Angel.
Tanks for your attention.
chears
HHbrazil. Penta soccer chanpions
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|