[pl/sql] PLSQL common configuration [transfer]

1. PL/SQL Developer remember the login password

When using PL/SQL Developer, I want PL/SQL Developer to remember the user name and password of logging in to Oracle for the convenience of work.

Setting method: PL/SQL Developer 7.1.2-> tools- > Preferences- > Oracle- > Logon History. "Store history" is checked by default. Check "Store with password". Log in again and enter the password once to remember it.

2. Execute a single SQL statement

When using PL/SQL Developer's SQL Window, press the F8 key. By default, PL/SQL Developer executes all the SQL statements of the window, which needs to be set to the SQL statement where the mouse is located, that is, to execute the current SQL statement.

Setting method: PL/SQL Developer 7.1.2-> tools- > Preferences-- > Window types, and tick "AutoSelect Statement".

3. Format SQL statements

When using PL/SQL Developer's SQL Window, sometimes the input SQL statement is too long or too messy. I hope we can write it in a more general format, so that it will look better and easy to analyze.

How to use: select the SQL statement that needs to be formatted, and then click the PL/SQL beautifier button on the toolbar.

4. View the execution plan

When using the SQL Window of PL/SQL Developer, sometimes the execution efficiency of the input SQL statement is analyzed. To analyze the structure of the following table and how to improve the efficiency of the query, you can check the execution plan provided by Oracle.

How to use it: select the SQL statement to be analyzed, and then click the Explain plan button on the toolbar (that is, execute the plan), or press F5 directly.

5. Debug stored procedures

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

The method of calling a stored procedure: first, select Procedures in the Browser on the left of PL/SQL Developer to find the stored procedure to be called; then, select the debugged stored procedure, right-click, and select Test. In the pop-up Test script window, for the parameter defined as in type, you need to input the Value of the parameter; finally, click the number of buttons above: Start debugger or press F9; finally, click: RUN or Ctrl+R

6. Window list is displayed in the lower left corner

Click the menu tools-> window list, drag the pop-up window to the appropriate location in the lower left corner, and then click the menu window- > save layout

7. Prevent login timeout

Tools- > Preferences-- > Oracle- > Connection Select "check connection"

8. Do not back up sql files

Tools- > Preferences- > Files- > backup. Select disabled article in backup files on the page from: http://www.cnblogs.com/dba001/archive/2011/02/26/1965645.html