Plsql Developer Tips for use

1. My Objects is automatically selected by default after login

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

Setup method:

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 order (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 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 to enter a password is meaningless, you can consider let Plsql developer remember the password.

Setup method: Menu Tools--Preferences----Oracle--Logon history---Store with Password

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

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.

Setup method: Menu Tools--Preferences---Keyword case-to-uppercase

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

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

7. The SQL window automatically selects the statement according to the cursor position/id is displayed as a number instead of as a binary form

Setup method: Preferences---window Types---SQL window, AutoSelect statement selected. Notice that you add a semicolon after each statement.
Setup method: Ditto, select number fields To_char
8. 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

Other than that

1) Enter it in the editor. , Plsql will perform auto-completion. Sometimes I feel uncomfortable with automatic hints. Slow speed. You can set the prompt key yourself.

Turn off Code AutoComplete first:

Tools->preferences->user interface->code assistant->automatically activated, deselect.

Set up shortcut keys to manually invoke AutoComplete:

Tools->preferences->user Interface->key Configuration.

Find Tools/code Assistant, modify for your favorite shortcuts, plsql developer8 default is F6.

It's OK:

Edit table is set to Ctrl+shift+e

Edit data, set to Ctrl+shift+d

Edit Spec & body, setting ctrl+shift+b

2) Customization Tips

Tools->preferences->edit->autoreplace

Edit save.

such as: S=select * from

Edit, I enter S and then click on the space, the content will automatically become a select * from, so that in the normal query when you do not have to enter the long string of select this character.

Tools->preferences->edit->syntax highlighting

By the way, change keyword case to uppercase.

3) Automatically save database password

Tools->preferences->oracle->logon history->definition

Choose store with password.

4) Font settings

Tools->preferences->fonts

I used to use the song Body number 9th.

Tools->preferences->edit->syntax highlighting

I used to take comment italic out of the body, italic can not see clearly ah.

5) F8 automatic execution of current row SQL

Tools->preferences->window Types->sql Window

Pick the AutoSelect statement.

Tools->preferences->edit->other

And by the way, add highlight edit line.

Plsql Developer Tips for use