Plsql Developer Common settings and shortcut keys

1. Automatically check my Objects after login (verified available)

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 measured in milliseconds.

Setup method:

The Tools menu--〉brower Filters opens the Order window for Brower Folders and sets "My Objects" to default.

Tools menu--〉brower Folders, put a few directories you often point (such as: Tables views Seq Functions Procedures) Move up a bit, and add color to distinguish, so your average time to find the table will be greatly shortened, try.

2. Remember the password

This is a controversial feature because remembering passwords can lead to data security issues. But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql Developer remember the password.

Setup method:

Tools menu--〉preferences--〉oracle--〉logon History--〉store with Password

3. Double-click to display table data (verified available)

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 fortunately this can be set, you can give the mouse double-click and drag and drop the required events, such as: Double-click Edit Data, play the display table structure, yeah!

Setup method:

Tools menu--〉preferences--〉browser, on the right, double-click (double-click Action) and drag-and-drop operations for a different object Type (such as select table) (Drag & Drop Action).

4, SQL statement characters all uppercase

Since this is a good habit, the core of the information system is the database, the first thing to look for when the system problem is the SQL statement, How to quickly find that SQL statement in the vast log is a painful thing. SQL statement capitalization does not solve this problem completely, but finding a line of all uppercase characters in the middle of a heap of code is relatively easy, and your eyes will thank you.
  
Setup method: Menu Tools--Preferences---Keyword case-to-uppercase


Strong>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!

Setting Method: Right--Special Copy


6, custom shortcut keys    

   Plsql developer has a lot of keys reserved for users to customize, which is a very high thing. Unlike the overbearing word, basically all the keys have been pre-defined features, the change is very headache. Usually, after opening Plsql developer, the most often do is to open the SQL window and Command window, the two operations have defined shortcut keys, alt+s and ALT + C, so that the mouse point three things only need to press the key.

Setting Method: Menu Tools--Preferences Key Configuration


7, SQL window automatically selects statements based on cursor position    

   Setup method: Preferences window Types--and SQL window, AutoSelect statement is selected. Notice that you add a semicolon after each statement.

8. Start Plsql Developer,window List menu automatically

A two-step setup is required to first save the desktop settings and then tick the window list option, as follows:
A, select option in the user interface in the Preference option under Tools in the menu item, and tick the front check box on the right for AutoSave desktop.
B. The window list option is checked under Tools in the menu item.

9. Formatted SQL (format)-pl/sql beautifier (verified available)

When you get a long SQL statement, you want to quickly see the logic, you can put it in this tool, format, the logic of the statement is clear

10. Automatic connection of database

Because the database does not operate for a period of time, it will automatically disconnect, and then need to manually connect themselves, because of the network, always stuck there. The tool provides the ability to detect connections, which can be automatically connected.

The specific settings are checked in front of the Tools-preferences-check Connection,check connection.

11. Common Shortcut keys

In fact these are mentioned in the 6th item, here are my custom settings:

Ctrl+tab Switch Windows window (or alt+left/right)

ALT + Q close the current window

SHIFT + Q Close all windows

12, two database differences (compare tables, views, functions, sequence structure)

Log in to the target library (Neuku), select Tools--Compare User objects,target session Select the old library, so you can compare it to provide Objects and update SQL that are different (SQL can be saved as command File, After the replacement user logs in to the old library, open and execute).

13. Execute a single SQL statement

When using PL/SQL developer, press the F8 key, PL/SQL developer is the default to execute all of this window, and need to be set to the SQL statement that the mouse, that is, the execution of the current SQL statement;

Setup method: PL/SQL Developer 7.1.2-->tools->preferences-->window types, check "AutoSelect Statement".

14. View Execution Plan

When using the SQL window of PL/developer, sometimes the efficiency of input SQL statement execution, analysis of the following table structure, how to improve the efficiency of the query, you can view the execution plan provided by Oracle;

To use: Select the SQL statement you want to analyze, and then click the Explain Plan button on the toolbar (that is, execution plan), or press F5 directly.

15. Debugging Stored Procedures

When using PL/SQL developer to operate Oracle, some stored procedures are sometimes called, or stored procedures are debugged;

Method of calling the stored procedure: first, select procedures in the browser to the left of PL/SQL developer to find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, and in the pop-up Test scrīpt window, For a parameter that is 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; Last click: RUN or Ctrl+r.

Plsql Developer Common settings and shortcut keys