PL/SQL Developer usage tips, shortcut keys

1, 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, First letter capitalization, etc.;

2, 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.

Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit

1), create a text file Shortcuts.txt, and write the following: S=select copy code is saved to PL/SQL Developer installation path under ~/plugins directory 2), tools–>preferences– >user Interface–>editor–>autoreplace, select the Enable check box, and then browse the file to select the Shortcuts.txt that 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 will not work

The following defines some rules as reference I=insert u=update s=select f=from w=where o=order by D=delete Df=delete from Sf=select * from Sc=select COUN T (*) from Sfu=select * from for UPDATE cor=create OR REPLACE p=procedure fn=function t=tigger v=view sso=set serveroutput On;

3, set the shortcut key (setting Method: Menu Tools (Tools) –>preferences (Preferences) –>user Interface (user interface) –>key configuration (key configuration))

New SQL window: Ctrl+shift+s

New command window: ctrl+shift+c

New Test window: ctrl+shift+t PL/SQL Developer

Beautification Device: Ctrl+shift+f

Redo: Ctrl+shift+z

Undo: Ctrl + Z

Clear: Ctrl+d (use caution, unrecoverable, 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

Search: Ctrl+f

Show Table structure: CTRL + mouse hover over table name

List of templates: Shift+alt+r

Window list: ctrl+w

Execute a single SQL statement: Press the F8 key

4. Set Remember Password (Setup method: Menu tools (Tools) –>preferences (Preferences) –>Oracle–> Login History

The store history is checked by default,

Tick "store with password (password storage)"

5, TNS Names: Menu Help->support info (support information)->tns Names, you can view the Tnsnames.ora of Oracle;

6. Debug stored procedures when using PL/SQL developer to operate Oracle, some stored procedures are sometimes called, or stored procedures are debugged; methods for calling stored procedures: 1), first, in PL/SQL Developer Select Procedures in the left browser to find the stored procedure that needs to be called, 2), then, select the stored procedure for debugging, right-click, select Test, in the Test Scrīpt window of the pop-up, for the parameter defined in type, You need to enter values for the value of this parameter, and finally click the number of bars button above: Start debugger or press F9; 3), Last click: RUN or Ctrl+r.

Debug shortcut key Toggle Breakpoint: Ctrl+b Start: F9 run: Ctrl+r Step into: CTRL + N Single Step skip: Ctrl+o Single Step exit: Ctrl+t Run to Exception: Ctrl+y

7. My Objects is automatically selected by default after login

By default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you will need to wait a few seconds for the tables directory to expand, and the response rate after selecting my objects is in milliseconds.

Setup method: Tools menu –>brower Filters, will open the Brower Folders Order window, the "My Objects" set as the 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