PLSQL Developer settings and shortcut key settings

1. After logon, My Objects is automatically selected by default. After PLSQL Developer logs on, All objects is selected in Brower. If the user you log on to is dba, expand the tables directory, in normal cases, Wait takes several seconds, and the response speed after selecting My Objects is calculated in milliseconds. Setting Method: Tools menu --> Brower Filters. The order window of Brower Folders is opened and "My Objects" is set to the default one. 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. 2. Remember the password is a controversial feature, Because remembering the password will bring 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-clicking displays the table data. double-clicking the table data and double-clicking the table or view shows the default response, which disappoint me, because I am most concerned about the table structure and data, but these two things did not happen after double-clicking, maybe the default response is required by experts, but for me, viewing data and table structure is the most important thing, 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. It is a good habit to assume that all SQL statement characters are capitalized. The core of the information system is the database. When the system has problems, 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. SQL statements written by special Copy in SQL Window usually need to be placed in Java or other languages, you need to convert it into a string and add the corresponding connection characters. You do not need to repeat this task. Right-click the prepared SQL statement and use the special Copy function! Setting Method: Right-click --> Special Copy 6. Many keys are reserved in the Custom shortcut key PLSQL Developer for user customization. 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. The SQL Window automatically selects the statement setting method based on the cursor position: Preferences --> Window Types --> SQL Window, select AutoSelect statement. Note that each statement must be followed by a plus sign. Supplement: 8. To start PLSQL Developer, it takes two steps to automatically bring up the window list menu. First, save the desktop settings and check the Window list option. The specific operations are as follows: a. select Option from the User Interface in Preference options under Tools of the menu item, and select the check box above in Autosave desktop on the right. B. Check the Window list option under Tools of the menu item. 9. format: When you get a long SQL statement and want to quickly view the logic, you can put it in this tool for formatting, the statement logic is clear at a glance. 10. The database automatically checks the connection status. Because the database is not operated for a period of time, it is automatically disconnected. Then you need to manually connect to the database. Due to network problems, always stuck there. The tool provides the connection detection function to automatically connect. You can select Tools-Preferences-Check connection and Check connection. 11. Common shortcut keys are mentioned in Item 1. below is my habit setting: ctrl + tab to switch to the windows window (or alt + left/right) alt + n create new SQL window alt + c close current window alt + f format SQL author motiftear