1, class SQL Plus Windows: File->new->command window, this is similar to Oracle's client tool SQL Plus, but it is much more useful. 2, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. 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, Initial capitalization, etc. 3. Review the Execution plan: Select the SQL statement you want to analyze, then click the Explain Plan button on the toolbar (i.e. execution plan), or press F5 directly; this is mainly used to analyze the efficiency of SQL statement execution, analyze the structure of the table, easy to provide a visual basis for SQL tuning; 4, Auto-replace: Fast input SQL statement, such as input s, press 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. Set Method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit1), create a text file Shortcuts.txt, and write the following: s= The Select replication code is saved to the ~/plugins directory under the installation path of PL/SQL Developer 2), Tools–>preferences–>user interface–>editor–> Autoreplace, select the Enable check box, and then browse the file to select the Shortcuts.txt you created earlier, click Apply. 3), restart PL/SQL Developer, enter the s+ space in the windows, sc+ space to do the test. Note: Shortcuts.txt cannot be removed, otherwise shortcut keys cannot be defined as a reference I=insertu=updates=selectf=fromw=whereo=order Byd=deletedf=delete Fromsf=select * Fromsc=select COUNT (*) Fromsfu=select * from for Updatecor=create OR Replacep=procedurefn=functiont=tiggerv=viewsso=set serveroutput on; Set shortcut (Setup Method: Menu Tools–>preferences–> User Interface – > key configuration) New SQL window: ctrl+shift+s new command window: ctrl+shift+c new Test window: Ctrl+shift+tpl/sql developer beautification: ctrl+shift+f Redo: Ctrl+shift +z Undo: Ctrl + Z clear: ctrl+d (use with caution, not recoverable, I am disabled O (∩_∩) o~) Check all: Ctrl + A indent: Tab cancel indent: Shift+tab uppercase: ctrl+shift+x lowercase: ctrl+shift+ Y Note: ctrl+h uncomment: ctrl+m find: ctrl+f display table structure: CTRL + hover over table name Template list: Shift+alt+r window list: ctrl+w5, execute a single SQL statement: Press F8 6, TNS Names: Menu help- >support info (support information)->tns Names, you can view the tnsnames.ora;7 of Oracle, debug stored procedures when using PL/SQL Developer Operations Oracle, sometimes some stored procedures are called, Or debug a stored procedure: 1), first, select procedures in the browser to the left of PL/SQL developer, find the stored procedure that needs to be called, 2), then, select the stored procedure for debugging, right-click, select Test, In the pop-up Test scrīpt window, for a parameter defined as an in type, you need to enter a value for the parameter's value; Last click the number of bars button above: Start debugger or press f9;3), and last click: RUN or Ctrl+r. Debug shortcut key Toggle Breakpoint: Ctrl+b Start: F9 run: Ctrl+r Single step: CTRL + N Step skip: Ctrl+o Single Step exit: Ctrl+t Run to Exception: Ctrl+y8, template shortcut 9, automatically check my Objects by default after login Plsql Developer Login, Brower will choose all objects, if you are logged in the user is a DBA, to expand the tables directory, the normal situation will need to wait a few seconds, and select my objects the response rate is in milliseconds. Setup method: Tools Menu –>browerFilters will open the Order window of Brower folders and set "My Objects" as default. Tools menu –>brower Folders The few directories you regularly order (e.g. Tables views Seq Functions Procedures) Move up a bit and color-coded so that your average look-up time will be much shorter and try. Priority, left-to-right tables–>tablespaces–>procedures–>users–>roles
PL/SQL Developer usage tips, shortcut keys