DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013

    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
    Pittsburgh, PA
    If you are using 10g or above put the folowing in your glogin.sql file.

    set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> "
    this space intentionally left blank

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.