Plsql tips on how to set the default display my Objects, remember passwords, etc.

1, PL/SQL developer remember login password
When using PL/SQL developer, you want PL/SQL developer to remember the username and password to log in to Oracle for your convenience;
Setup method: PL/SQL Developer7.1.2->tools->preferences->oracle->logon history, "Store" is checked by default, tick "store With password "can, re-login in the input password once remember.

2. 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;
Setting method: PL/SQL Developer7.1.2-->tools->preferences-->window types, hook on "AutoSelect Statement" can.

3. Formatting SQL statements
When using PL/SQL developer, sometimes the SQL statement entered 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.

4, select Row Highlight
Preferences-->user Interface-->editor-->other-->highlight Edit Line

5. Double-click to display the 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, yeah!
Setup method: Menu Tools---Preferences--Browser, on the right, double-click and drag-and-drop operations for different object types.
　　

6. 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.
Setup method: Menu Tools--Preferences---Keyword case-to-uppercase

　　
7. Special Copy
SQL is written in SQL window usually need to put 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

8, Code Auto-complete Settings
  Tools, preferences   user Interface (editor)--autoreplace---Enabled=true Enter the keywords you want to replace and save them.
 
 
9, automatically check my objects  after login
  By default, developer will select all brower when the Plsql Objects is logged in. If you are logged in 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, the Order window for Brower folders is opened and the "My Objects" is set to default.
 tools Menu--brower Folders, the several directories you often order (for example: Tables views Seq Functions Procedures) Move up a little, and add color to distinguish, This way your average look-up time will be greatly shortened, try it.


10, custom Shortcuts   
Plsql Developer has a lot of keys reserved for users to customize, which is a very hight 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.
Setup method: Menu Tools--Preferences Key Configuration

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

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

　
13. 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----autoreplace. -Edit
The following defines some rules as a reference
S=select
F=from
W=where
O=order by
D=delete
Sf=select * FROM
Df=delete from
Sc=select COUNT (*) from

Transferred from: http://blog.csdn.net/nomousewch/article/details/8699583

Plsql tips on how to set the default display my Objects, remember passwords, and so on