Plsql configuration settings

1, the default is automatically selected after login myobjects

By default,plsqldeveloper login,Brower will choose allobjects, 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, The response rate after selecting My objects is measured in milliseconds.  

Setup method:Tools menu-browerfilters, will open the browerfolders Order window, the "Myobjects" set as the default. in the same vein, you can move afew directories (such astablesviews Seq Functions Procedures) that you regularly point to in the Tools menu-Browerfolders, and color-coded so that your average look-up time will be greatly shortened, try it.

2. Remember the 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

3. Double-click to display the table data

The default response when you double-click a table or view in the mouse is disappointing, because I am most concerned about the table structure and data, but the two things do not happen after double-click, 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,yeah!  

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

4.SQL statement characters all uppercase

Think this is a good habit, the core of the information system is the database, the first thing to check when the system problem is the SQL statement, how to quickly find that SQL statement in the vast log is a more 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.

Setting method:preferences--userinterface--editor--keywordcase--uppercase

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!

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

8, pl/sqldeveloper Remember login password
using pl/sqldeveloper Remember login oracle User name and password;
Set   method: pl/sqldeveloper 7.1.2  ->tools-> Preferences->oracle->logonhistory, "Storehistory" is the default check, tick " Storewithpassword " , re-login at the time of entering the password is remembered.

9, execute a single sql statement
using pl/ Sqldeveloper sqlwindow, press f8 Key, pl/ Sqldeveloper default is all sql statement that executes the window, which needs to be set to the sql statement where the mouse is located, that is, executing the current
Setting method: pl/sqldeveloper 7.1.2-->tools->preferences--> Window types , "autoselectstatement"   can be checked.

10. Formatting SQL statements
In the use of Pl/sqldeveloper Sqlwindow, sometimes the input SQL statement is too long or too messy, I hope to use a more general format words, so look good, or analysis;
How to use: Select the SQL statement you want to format , and then click the pl/sqlbeautifier button on the toolbar.

11. View Execution Plan
When using Pl/sqldeveloper's Sqlwindow, 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 , then click the Explainplan button on the toolbar (that is, execution plan), or press F5 directly.

12. Debugging Stored Procedures
When using Pl/sqldeveloper 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/sqldeveloper , find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, Out of the Test scrīpt window, for a parameter defined in type, you need to enter a value for the parameter's value ; Last click the number of bars button above:Startdebugger or press F9; Last click: RUN or ctrl+r

13. The lower left corner shows windowlist
Click menu Tools, Window list, drag the small pop-up window to the lower-left corner, and then click menu window->savelayout

18. Prevent Login Timeouts
Tools->preferences-->oracle->connection Select "Check Connection"

19. Do not back up SQL files
Tools->preferences->files->backup, Select disabled in the backup Files page

Plsql configuration settings