TO Rohitsn
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: TO Rohitsn

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Talking

    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???

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Wink

    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
  •  


Click Here to Expand Forum to Full Width