Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1022
  • Last Modified:

SQL+ and the login window


I was wondering if it was possible to have informations (login & Host String) entered automatically at the Login Window in Oracle SQL+7 or 8? I hope you know what I'm talking about...

Login Window            |
Login:                  |
Password:               |
Host String:            |

Thank you
1 Solution
You can include the login information in the windows shortcut used to start SQL*Plus. The command string in the shortcut should be like that:
<oracle home path>\bin\SQLPLUSW.EXE username/pwd@sid

Hope that helps!
I am not sure if you can display the information like this in your login window. But what you can sure do is to change the property of the shortcut and pass the login credentials to the SQLPLUSW.EXE program to get logged in automatically by double clicking it.

Right click on the shortcut and go to Properties tab. In the text box for TARGET change <orahome>\bin\SQLPLUSW.EXE to
<orahome>\bin\SQLPLUSW.EXE <userid>/<password>@<hoststring>.

<orahome> should be the path where Oracle is installed.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now