DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: change my sql prompt

  1. #1
    Join Date
    Jan 2013
    Posts
    1

    change my sql prompt

    I want to use my username and my SID as a Prompt, and here is a condition, that I m using my single Oracle Home for the two databases both are on the 10g, and here what I needed
    1- when I login to the database it asks for the database name like "Enter the database name Prod1 - ?
    2- then it checks from which database I have logged in like from Prod1 or Prod2 and then it shows me the sql command prompt like "username@prod1>"

    I am using my glogin.sql file for login to the database. Is any body have a solution to edit my glogin.sql file for doing all these task.
    Thanks for ur support

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    If you are using 10g or above put the folowing in your glogin.sql file.

    set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> "

Tags for this Thread

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