About SQL Plus prompt
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: About SQL Plus prompt

  1. #1
    Join Date
    Nov 2003

    About SQL Plus prompt

    In login.sql, I have added
    column global_name new_value gname
    set termout off
    select lower(user) || '@' || name global_name from v$database
    set termout on
    set sqlprompt '&gname> '

    But when I connect to other user in SQL PLUS, the prompt cannot be change?

    manger@testing>conect test/test@testing

  2. #2
    Join Date
    Sep 2002
    that wont re-read your login.sql unless you do @login.sql.
    do do a script called connect.sql

    which does
    connect $1

    where $1 is the connect string

    This is fixed in 10g by the way

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