Plsql Developer Common Skills

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: Tools->preferences->oracle->logon History, "store" is the default check, tick "store with password", Re-login at the time of entering the password is remembered.

2. 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;
To use: Select the SQL statement that you want to format, and then click the PL/SQL Beautifier button on the toolbar.

3. Auto-replace function
Tools->preferences->editor->autoreplace-> Select the enabled, and edit the file, adding the following content:

S=select * FROM
I=insert into
D=delete from
F=for UPDATE
U=update
gb* = GROUP by
us* = UPDATE SET
W = WHERE
Ob* =order by
tc*= trunc (sysdate)
td*= to_date (', ' YYYYMMDD ')
tch*= to_char (, ' YYYYMMDD ')

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

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

Plsql Developer Common Skills