Some PLSQL developer settings

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 --> Object Brower filters. The order window of Brower folders is opened, and "my objects" is set to default.

Tools menu --> Object Brower folders, which moves the directories (for example, tables views seq functions procedures) that you frequently click to a point and adds the color to differentiate them, in this way, the average table searching time will be greatly shortened. Try again.

2. Remember the password

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.

Setting Method: menu tools> preferences> Oracle> logon history> store with Password

 

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> browser to 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.

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