Set Plsql to start automatic logon to the specified database

Set Plsql to start the Automatic logon database

In a company project, there are multiple test environments, often with different databases when DEUBG problems. Although Plsql can save the login user name and password, but each time you choose a row of databases in the selection of the time it is easy to see preoccupied, there is no convenient way to log in directly to the database.

When looking at Plsql's help documentation, I found that 33.4 had this passage:

Userid
Every time you start PL/SQL Developer, it'll prompt you to at least the password. To avoid this, you can supply a userid parameter with the familiar Username/[email protected] format:
Plsqldev.exe Userid=scott/[email protected]
Note so you can also use the following registry key to supply a default logon:
Hkey_current_user\software\allround Automations\pl/sql Developer\logon
Here you can add a Username, Password and Database.
The last method had the advantage that it enables you to be automatically logged on after double clicking a PL/SQL Develop ER registered file.

That is, when you run Plsqldev.exe, with the "user= login Information" parameter appended to it, Plsql automatically logs on when it is started, so creating a plsql shortcut with a different database connection can be achieved.

Open the Plsql installation directory, right-Plsqldev.exe, select Send To-desktop shortcut, right-click on the Desktop plsqldev.exe-shortcut file-Properties, after the target quotation marks, plus the database connection information, in the following format:

user= username/password @ database address

Create multiple shortcuts, one for each database, and a different name to make it look beautiful.

Set Plsql to start automatic logon to the specified database