PL/SQL Developer Usage tips and shortcut key settings

1. Class SQL Plus window:

File->new->command Window, which is similar to Oracle's client-side tool SQL Plus, is much more useful than the sqlplus in CMD.

2. Set keywords to capitalize automatically:

Tools->preferences->editor, select the keyword case 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.;

3, remember the login username and password

This is a controversial feature because remembering passwords can be a problem for data security. But if it is the development of the library, the password can even be the same as the user name, each time the password is meaningless, you can consider let plsqldeveloper remember the password.  

Setup method:Tools menu,preferences->oracle->logonhistory->storewith password

4. double-click to display table Data

The default response when the mouse double-clicks a table or view is disappointing because I am most concerned with the table structure and data, but the two things do not happen after double-clicking, perhaps the default response is the master needs, but for me to view the data and table structure is the most important, the other I do not care. But the good thing is this can be set, you can give the mouse double-click and drag and drop the required events, such as: Double-click Edit Data, drag and drop display table structure.  

Setup method:preferences--Userinterface--browser, on the right, double-click and drag-and-drop operations for different objecttype.

5. Special Copy

SQL statements written in SQL window usually need to be placed in Java or other languages, you need to turn into a string and add the corresponding hyphen, this thing does not need to repeat, in the written SQL right-click, using special copy is ok! If you re-edit the special copy file yourself, the directory is: Specialcopy folder in the Plsql installation directory.

Setup method: Right- --special copy

6. Custom shortcut keys

Plsql developer has a lot of keys reserved for users to customize, which is very hight thing. Unlike the overbearing Word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening plsqldeveloper, the most frequently done thing is to open Sqlwindow and CommandWindow, the two operations have defined shortcut keys,alt+s and ALT + C, So take the mouse to point three things only need to press the key.

Setting method:preferences--userinterface--keyconfiguration

7. Prevent login Timeout

Tools->preferences-->oracle->conne ction Selection "Check Connection".

8 , do not back up sql file
Tools-> Preferences->files->backup, page backup Files select  disabled.

9, Debug stored procedure
using pl/sqldeveloper operation oracle, sometimes some stored procedures are called or stored procedures are debugged, methods of calling stored procedures: first, pl/ Sqldeveloper to the left of browser select procedures to find the stored procedures that need to be called; then, select the debug stored procedure, right-click, select the Span lang= "en-us" >test, in the pop-up test scrīpt window, for parameters defined as in type, you need to give this parameter value input value; Last click the number of bars button above: startdebugger or press F9; Last click: run or ctrl+r.

10. Automatically SELECT statements based on cursor position in SQL window

Setup method:preferences--windowtypes--sql Window, select Autoselectstatement.
Notice that you add a semicolon after each statement.

11, execute a single sql statements
when using pl/sqldeveloper sqlwindow, press f8 Key, pl/sqldeveloper by default is all sql statements that execute the window and need to be set to the one where the mouse is located sql statement, that is, the execution of the current sql statement;
Setting method: pl/ Sqldeveloper 7.1.2-->tools->preferences-->window types, hook "autoselectstatement" can be.

12, automatic replacement:

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.

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

1), create a text file Shortcuts.txt, and write the following content:
I=insert
U=update
S=select
F=from
W=where
O=order by
D=delete
Df=delete from
Sf=select * FROM
Sc=select COUNT (*) from
Sfu=select * from for UPDATE
Cor=create OR REPLACE
P=procedure
Fn=function
T=tigger
V=view
Sso=set serveroutput on;
2), 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.

13, for the above configuration, will be recorded in the installation path under the Preferences/plsql installation of the user name folder, as shown in:

　　

　　Note the two folders under the Preferences directory are backed up before reloading.

PL/SQL Developer Usage tips and shortcut key settings