Oracle Database PL/SQL shortcut key settings

This document describes how to set the shortcut keys for PL/SQL in Oracle databases, this includes setting My Objects, remembering the password, and double-clicking to display table data by default after logon. We hope this will help you. In Oracle databases, the PL/SQL shortcut setting method is what we will introduce in this article. We understand that these settings can be used more efficiently by using Oracle databases, next let's take a look at this part.
1. After logon, My Objects www.2cto.com is automatically selected by default. 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. Www.2cto.com 4. It is a good habit to write SQL statements in uppercase. The core of the information system is the database. When a 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. 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. Www.2cto.com 8. automatically replace the shortcut input SQL statement, for example, enter s, Press space, and replace it with SELECT; for example, input sf, Press space, and then replace it with SELECT * FROM, it is very convenient and saves a lot of time to write repeated SQL statements. Setting Method: menu Tools> Preferences> Editor> AutoReplace. --> Edit describes how to set shortcuts for Oracle Database PL/SQL. I hope this introduction will be helpful to you!