![]() ![]() The following defines some rules as a reference Note: Shortcuts.txt cannot be removed, otherwise shortcut keys will not work Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>editġ), create a text file Shortcuts.txt, and write the following content:Ĭopy code is saved to the ~/plugins directory under the PL/SQL Developer installation pathĢ), Tools–>preferences–>user interface–>editor–>autoreplace, select the Enable check box, Then browse to the file and select the Shortcuts.txt you created before clicking Apply.ģ), restart PL/SQL Developer, enter the s+ space in the windows, sc+ space to do the test. execution plan), or press F5 directly this is mainly used to analyze the efficiency of SQL statement execution, analyze the structure of the table, so as to provide a visual basis for SQL tuning ģ, automatic replacement: Fast input SQL statements, such as input s, press the space, automatically replaced by select for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements. ![]() Review the execution plan: Select the SQL statement you want to analyze, then click the Explain Plan button on the toolbar (i.e. This is easy to read code, and to maintain a good coding style, in the same way, in Tools->preferences->code Assistant (assistant) can set the code hint delay time, enter a few characters when prompted, the database object uppercase, lowercase, First letter capitalization, etc. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. ![]() PL/SQL Developer usage tips, shortcut keysġ, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |