Summary of PLSQL shortcuts and tips

Summary about the shortcut keys and usage skills of PLSQL recently encountered some troubles in the development process, that is, the development efficiency problem. Sometimes other colleagues use PLSQL to program more efficiently than themselves, I found that he has been using PLSQL for a long time, and he has added many shortcuts in it. 1. After logging on, My Objects is automatically selected by default. After PLSQL Developer logs on, in Brower, All objects will be selected. If the user you log on to is dba, you need to expand the tables directory. Normally, Wait takes several seconds, after selecting My Objects, the response speed is calculated in milliseconds. Www.2cto.com setting method: Tools menu --> Brower Filters, opens the order window of Brower Folders and sets "My Objects" as the default value. 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. 8. automatically replace www.2cto.com with the shortcut input SQL statement, for example, input s, Press space, and then replace it with SELECT; for example, input sf, Press space, and automatically 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. --> below Edit, some rules are defined as reference s = SELECTf = FROMw = WHEREo = ORDER BYd = DELETEsf = SELECT * FROMdf = DELETE FROMsc = select count (*) FROM another 1) enter. plsql runs automatically. sometimes it is uncomfortable to automatically prompt. slow speed. you can set the prompt key by yourself. turn off the Code and then click "Tools"> "Preferences"> "User Interface"> "Code Assistant"> "Automatically activated" to cancel the selection. Set the shortcut Key for manual call to automatically complete: Tools-> Preferences-> User Interface-> Key Configuration. Find Tools/Code Assistant and change it to your preferred shortcut key. The default value of Plsql Route 8 is F6. You can also set www.2cto.com Edit table to ctrl + shift + E Edit data, ctrl + shift + D Edit spec & body, and ctrl + shift + B 2) the custom prompt Tools> Preferences> Edit> AutoReplace Edit is saved. For example, in s = SELECT * FROM Edit, I enter s and press a space to automatically convert the content to SELECT * FROM, in this way, you do not need to input the select long string every time during regular queries. tools-> Preferences-> Edit-> Syntax Highlighting change Keyword case to Uppercase by the way. 3) automatically save the Database password Tools> Preferences> Oracle> Logon History> Definition and select Store with password. 4) font settings Tools-> Preferences-> Fonts I used to use the 9 9 9. Www.2cto.com Tools-> Preferences-> Edit-> Syntax Highlighting I used to remove the Italic of Comment, but I cannot see it clearly. 5) F8 automatically runs SQL Tools> Preferences> Window Types> SQL Window to select AutoSelect statement. Tools-> Preferences-> Edit-> Other add Highlight edit line. Author: zmyxmjz