PL/SQL Developer Configuration User Manual (collation)

PL/SQL Developer Configuration User Manual (collation)

1. Remember login password

steps: " Tools", "Preferences", [left panel] "Oracle---" Logon history ", tick the" Store with?password "option, as shown in:

?

2. Set the execution of a single SQL

Note: By default, all SQL statements for the window are executed by F8, which implements the SQL statement that only the mouse is executing.

steps: " Tools"-"Preferences"--[left panel] "window Types and SQL window", tick the "autoselect Statement" option, as shown in:

?

3. Fast Input Code

Note: This feature implementation needs to install the Cnplugin plug-in,:http://download.csdn.net/detail/czw2010/6942275, select one-click installation, install the configurable shortcut code, as shown, We just enter S and press SPACEBAR, which becomes select * from.

Note: Cnplugin will cause some operating system input stutter phenomenon!

plsql Developer 11.06. Version 1776 does not support Cnplugin

4. Auto-capitalization of keywords

Note: keyword capitalization is primarily convenient for querying the corresponding statements in the log.

steps: Tools, Preferences->[left panel] "User Interface--? Editor, select uppercase keyword Case drop-down, as shown in:

?

5. Using special copy (special copy)

Note: We often need to put SQL script statements into a variety of development languages, and we can use the special copy function to convert a single key into a stitched SQL string.

steps: Select the appropriate development language for special copy, right-click SQL statement

Custom Special Copy Format--? supplement at 2016-6-6?:

Go to the PL/SQL installation directory, locate the Specialcopy file, and open the configuration file that can see the various formats in copy, as shown in:

I modified the Java format Copy to: Sqlbuffer.append ("xxxx") format:

[plain]? View plain? Copy

?

2. ;P l/sql? Developer? Specialcopy?definition??
4. ; <line_1>?for?first?line??
6. ; <line_*>?for?all?other?lines??
8. ; <line_n>?for?last?line??
10. ;??
12. #define? " =?\"??
14. #define? \?=?\\??
16. #define? char (9)? =?\t??
18. ???
20. ???
22. Sqlbuffer.append ("<LINE_1>?")??
24. ?????????. Append ("<LINE_*>?")???
26. ?????????. Append ("<line_n>");??

?

6. Characters that do not display the scientific notation

Note: When the value of the table field is too long, it is shown in scientific notation, it is inconvenient to copy, so you can configure it to display the full value by default.

steps:? "Tools", "Preferences", "Window Types", "SQL window", tick the Number fields to_char options, such as:

?

7. Null value configuration different color value area separate

The field values we query are likely null values, tab, and other invisible fields, and the null values are different from them, so you can customize the color of a null value by customizing the configuration colors to clearly show that the field value is a null value or a special invisible field such as a space, tab, and so on:

Step: "Tools", "Preferences", "Window Types", "SQL window", select the color value of NULL value cell color

Test:

?

Appendix: Common Shortcut Keys

ALT + F: Landscaping/formatting

F5: View Execution plan

Note: Dig a hole, keep learning to update ...

Turn from: http://blog.csdn.net/chen_zw/article/details/19563207

Copyright NOTICE: This article for Bo Master original article, reproduced please indicate the original source, thank you!

PL/SQL Developer Configuration User Manual (collation)