1. My Objects is automatically selected by default after login
by default, Plsql developer log in, Brower will select all objects, if you are logged on as a DBA, to expand the tables directory, normally wait a few seconds, and select my The response rate after objects is measured in milliseconds.
Setup Method:
Tools menu--Brower Filters opens the Order window for Brower folders and sets "My Objects" to default.
Tools menu--brower Folders, put a few directories you often order (such as: Tables views Seq Functions Procedures) Move up a bit, and add color to distinguish, so your average time to find the table will be greatly shortened, try. 2. Remember the password
This is a controversial feature because remembering passwords can be a problem for data security. But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql developer remember the password.
Setup method: Menu Tools --Preferences----Oracle--Logon history---Store with Password3. Double-click to display the table data
The default response when the mouse double-clicks a table or view is disappointing because I am most concerned with the table structure and data, but the two things do not happen after double-clicking, perhaps the default response is the master needs, but for me to view the data and table structure is the most important, the other I do not care. But the good thing is this can be set, you can give the mouse double-click and drag and drop the required events, such as: Double-click Edit Data, drag and drop display table structure, yeah!
Setup method: Menu Tools---Preferences--Browser, on the right, double-click and drag-and-drop operations for different object types. 4. SQL statement characters all uppercase
think this is a good habit, the core of the information system is the database, the first thing to check when the system problem is the SQL statement, how to quickly find that SQL statement in the vast log is a more painful thing. SQL statement capitalization does not solve this problem completely, but finding a line of all uppercase characters in the middle of a heap of code is relatively easy, and your eyes will thank you.
Setup method: Menu Tools --Preferences---Keyword case-to-uppercase5. Special CopySQL is written in SQL window usually need to put in Java or other languages, you need to turn into a string and add the corresponding hyphen, this thing does not need to repeat, in the written SQL right-click, using special copy is ok!
Setup Method: Right--Special Copy6. Custom shortcut keys
Plsql developer has a lot of keys reserved for users to customize, which is very hight thing. Unlike the overbearing word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening Plsql developer, the most often do is to open the SQL window and Command window, the two operations have defined shortcut keys, alt+s and ALT + C, so that the mouse point three things only need to press the key.
Setup method: Menu Tools---Preferences Key Configuration7. Automatically SELECT statements based on cursor position in SQL window
Setup Method: Preferences---window Types---SQL window, AutoSelect statement selected. Notice that you add a semicolon after each statement.
Reprint: PL/SQL developer use tips
