Easy-to-use PL/SQL Developer settings, pldeveloper

Easy-to-use PL/SQL Developer settings, pldeveloper
Some time before the easy-to-use PL/SQL Developer settings, the company trained pl/SQL related knowledge internally. Here I will share my settings that I think are very convenient. 1. When PL/SQL Developer is used, PL/SQL Developer needs to remember the username and password for logging on to Oracle for convenience;
Setting Method: PL/SQL Developer-> tools-> Preferences-> Oracle-> Logon History. "Store history" is selected by default. Check "Store with password, remember to enter the password once you log on again.

2. Automatic uppercase of keywords
Tools-> Preferences-> Editor: Select Uppercase for Keyword case.

3. Execute a single SQL statement
When you use the SQL Window of PL/SQL Developer, press F8. By default, PL/SQL Developer executes all SQL statements in the Window and must be set to the SQL statement where the mouse is located, execute the current SQL statement;
Setting Method: PL/SQL Developer --> tools-> Preferences --> Window types --> SQL Window. Just check "AutoSelect Statement.

4. display the row number.

5. highlight selected rows.
6. Format beautification. Original statement style.
Click "pl/SQL beautifier.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.