PL/SQL Developer usage tips, shortcut keys

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.