PLSQL automatic login, remember the user name and password & amp; daily use skills, plsql Automatic Login

PLSQL automatic login, remember the user name and password & daily use skills, plsql Automatic Login

Https://www.cnblogs.com/Chary/p/No00008F.html

Configure the login username and password at startup

This is a controversial feature, Because remembering the password will cause data security issues. However, if the password is the same as the user name in the development database, it makes no sense to enter the password each time. Therefore, PLSQL Developer can remember the password.

1. If only one database is logged on, the user name and password are fixed. You can modify the shortcut of the program execution:

Create a shortcut for plsqldev on the desktop, right-click it, open the Properties dialog box, and enter in the text box behind the target:

"D: \ Program Files \ PLSQL Developer \ plsqldev.exe" userid = uname/upwd@172.16.89.22/dbname

The above two lines can be used to directly log on to the dbname oracle database with the uname username and upwd password without line breaks.

2. log on to multiple databases, or a database with multiple users and passwords. Modify PLSQL options (Tools> Preferences) (Tools> Preferences in Chinese ), remember the username and password for logging on to Oracle, and then select the desired user when starting the program, as shown in.

 

Click the button next to the user name and select the logon User:

 

Let PLSQL remember the username and password you have logged on

1. Save the user name

Tools-> Preferences-> User Interface-Options

Select Autosave username and save it.

2. Save the password

1. tools-> Preferences-> Oracle-> logon History-> fixed user

In the format of user/password @ database, add a fixed user and save it.

Appendix: Other Tips

1. My Objects is automatically selected by default after logon.

By default, after PLSQL Developer logs on, All objects will be selected in Brower. If the user you log on to is dba, it will take several seconds to expand the tables directory, after selecting My Objects, the response speed is calculated in milliseconds.

Setting method:
Tools menu --> Brower Filters. The order window of Brower Folders is opened, and "My Objects" is set as the default.
Tools menu-Brower Folders: Move the directories you frequently clicked (for example, Tables Views Seq Functions Procedures) to a higher level and add colors to differentiate them, in this way, the average table searching time will be greatly shortened. Try again.

3. Double-click to display table data

The default response when double-clicking a table or view is really disappointing, because I am most concerned about the table structure and data, but none of these two things happen after double-clicking, the default response may be required by experts, but it is important for me to view data and table structures. I don't care about others. However, this can be set. You can double-click and drag and drop the mouse to bind the required event, for example, double-click to edit the data, drag and drop to display the table structure, Yeah!

Setting Method: choose Tools> Preferences> Object Browser and bind double-click and drag-and-drop operations to different Object types on the right.

4. All SQL statement characters are in uppercase

I think this is a good habit. The core of the information system is the database. When the system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful. SQL statements in uppercase cannot completely solve this problem, but it is easier to find a line of all uppercase characters in the middle of a pile of code. Thank you in your eyes.
Setting Method: menu Tools> Preferences> Editor> Keyword Case> Uppercase

5. Special Copy

The SQL statements written in the SQL Window usually need to be placed in Java or other languages, and you need to convert them into strings and add the corresponding hyphens. This does not need to be repeated, right-click the prepared SQL statement and use the special Copy function!

Setting Method: Right click --> Special Copy

6. Custom shortcut keys

PLSQL Developer reserves a lot of keys for user customization, which is very high. Unlike the domineering Word, basically all the keys have predefined functions, and it is a headache to modify them. Generally, after you open PLSQL Developer, the most common task is to open SQL Window and Command Window. The Shortcut Keys ALT + S and ALT + C are defined for these two operations, in this way, you only need to press the key to take the mouse three times.

Setting Method: menu Tools> Preferences> Key Configuration

7. automatically select a statement based on the cursor position in the SQL Window

Setting Method: Preferences --> Window Types --> SQL Window. Select AutoSelect statement. Note that each statement must be followed by a plus sign.

After adding a semicolon, press F8 to execute the row where the cursor is located.

8. automatic replacement

Quick SQL statement input, for example, input s, Press space, and automatically replace with SELECT; for example, input sf, Press space, and automatically replace with SELECT * FROM, which is very convenient, it saves a lot of time to write repeated SQL statements.

Setting Method: menu Tools> Preferences> Editor> AutoReplace. --> Edit

 

9. PLSQL display results show Long data as characters

Tools-> Preferences-> SQL Window check Number fields to_char

10. Execute the SQL statement and export the query result to Excel:

View comments