Plsql Developer 11 Usage tips (continuous update)

plsql Developer 11 Usage tips (continuous update)

Directory (?) [-]

2. First of all, my color configuration.
4. Common shortcut keys
6. Improve Plsql programming efficiency
1. Auto-replace by space
2. Close Windows window
8. Plsql Practical Tips
1. TIP 1 Click into view mode
2. TIP 2 Stored Procedure debug Single Step execution
3. TIP 3 Changing the folder color
4. TIP 4 Save page layout
5. TIP 5 Chinese display problem
6. TIP 6 code highlighting and using bookmarks
7. Shortcut keys for the TIP 8SQL window are useful
8. TIP 9 Windows list name does not show down
9. TIP 9.5 Multiple cases for important window suggestions use right-rename to change to a meaningful window name to avoid mis-operation to close the important windows
10. TIP 10 single Execution SQL statement!
11. TIP 11 Let Plsql developer remember login password useful
12. TIP
13. TIP Keyword Auto capitalization useful
14. TIP 10
15. Right-click menu
16. TNS Names
17. Copy to Excel
18. Keep the last open SQL script
19. Quickly find tables or other objects with known table names
20. Quickly close the document window that opens in Windows list easy to use
21. A simple way to copy Row Records in Plsql developer
22. Displays the full path of the file in the window title bar
23. Double-click to display table data is important
24. Delete a line Ctrl + Y/D
25. SQL Windows is not careful.
26. New Practical shortcut keys
    1. Sort
    2. Go to the end of the line
    3. Display special characters (spaces, line breaks)

First of all, my color configuration.

The color schema of the referenced Monokai, where
Keywords keyword: bright red
Comments notes: Cyan Grey (italic)
Strings string: Gold
Numbers Number: Cyan
Symbols symbol: Bright red
Custom text: Bright red
Background background: dark grey or black

Common shortcut keys

Shortcut key Editor Entry:
Tool--perference, User Interface, Key Configuration

**undo:ctrl + Z
Redo:ctrl + Shift + z**

Select a shortcut key up or down on the Window list:
Previous window: Ctrl +1
Next window: Ctrl +3

Color Mark:shift + C
Upper Case:ctrl + Shift + D
(Lower Case:ctrl + Shift + C)

Go to line Ctrl + G

According to your preference, execute to F5.
View Execution Plan F8

Improve Plsql programming efficiency by 1. (by Space) auto-replace:

Setup method:
Tools, preference–> editor–> autoreplace (auto-replace) –> Edit

SXF=SELECT *  fromSCF=SELECT COUNT(*) froms1f=SELECT COUNT(1) fromisit=INSERT  intoDEFM=DELETE  fromOrb=ORDER  byGRB=GROUP  byprb=PARTITION byCor=CREATE OR REPLACEAltert=ALTER TABLEdropt=DROP TABLEFGX=-------------------------------Sso=SETServeroutput on;p utline=Dbms_output.put_line ();

2. Close window

Press CTRL + LEFT mouse button to close the window that opens in the list of Windows

Plsql Practical Tips:

TIP 1: Click into view mode

Window list, click any object to enter view mode, it is very convenient to operate
Of course, if you have a big heart, you can set it to "click into edit Mode"
but the window is more open and it's easy to do wrong.

TIP 2: Stored procedure debug Single Step execution

For stored procedures, if the debug process is not stepping, the result is returned directly,
Right-click->procedure->add Debug information now required

TIP 3: Change the folder color

The effect of the change is as follows:

Configuration method:
Tools, Perferences, Object Brower Folders
Opens the Define Browser folders interface, where you can make a distinction between several commonly used directories, such as Tables, Packages, procedures, functions color and general yellow, or sort the move up a bit, This will shorten your average time-to-table.

TIP 4: Save the page layout

Save the page layout to prevent the next startup and configuration to change back again

TIP 5: Chinese Display issues

Build batch file Start pld a little bit low~, I'm used to configuring environment variables
Nls_lang=simplified Chinese_china. Zhs16gbk
Lang=zh_cn. GBK

TIP 6: Code highlighting and using bookmarks

Code highlighting & using bookmark bookmarks
Can jump to a line quickly
Much faster and more flexible than annotations
After the code finishes writing the test, you can delete all the bookmarks and add the comments to make it easier for someone else to maintain your code after you die.
My Highlight shortcut key setting is: Ctrl+shift+c; A second click is Cancel

TIP 8:sql window shortcut keys are useful!

Shortcut key Settings
New SQL window Shift+ctrl+s ( must have )
Or you can create a shortcut key in the toolbar,

TIP 9:windows list name doesn't show down

The window list shows that the name is too long to display the whole word
You can see the process name directly, do a day's work, and the final window list is full, this time it shows the effect!!!
The disadvantage is that you can not see the Open edit page or browse the page, easy to cause misoperation
:

TIP 10: Useful!

Execute a single SQL statement preference, window types (3)->sql window, tick "AutoSelect Statement".

TIP 11: Make PL/SQL developer remember login password useful!

(under the hand escudo words suggest not to open, if the operation of the word does not matter)
Setup method:
Logon history, Oracle, Tools, perferences
"Store History" is checked by default, check "store with password", re-login in the password once entered remember.

tip.12 beautification Device

PL/SQL Beautifier (PL/SQL beautification/formatting) is important!
PLD 6 or later has the ability to format DML code. Select the part of the code in the SQL window or program window (if you don't select the entire window's code action), and in the menu, choose Edit-PL/SQL Beautifier to get the formatted code. For illegal DML statements or DDL statements, PLD will prompt PL/SQL Beautifier could not parse text in the status bar below.
In the default state, PLD will arrange each field of the DML statement in a separate line, so it is not easy to see.
In the menu, choose Edit PL/SQL Beautifier options, go to Preferences window, select Edit, enter the profile editing interface:
Select DML in the tab bar, choose Fit in the Select, Insert and update groups box in the middle of the window, then click Save, Save the profile to the PLD installation directory, and click Close. In the rules file, enter the location of the configuration file, click OK to complete the profile switch. Then you can format the code so that each field is as close as possible on one line.

TIP: Keyword auto capitalization is useful!

Tools->preferences->editor, select the keyword case uppercase.

14 The order of the custom object and the default auto-check my objec after login is useless!!!by default, after PL/SQL developer is logged in, Brower selects all Objects .

If the user you are logged in to is a DBA, to expand the tables directory, wait a few seconds for the normal situation,
The response rate after selecting my objects is measured in milliseconds.
Setup method: Tools menu, Object Brower Filters, will open define Browser Filters interface, check "My Objects" and tick "default" to set as default.

15. Right-click menu

In the PLD every text editing window, such as SQL Window,command window and Porgram window, right click on an object name, will pop up a menu containing the Action Object command, we call it a right-click menu.
Object types can be tables, views, synonyms, stored procedures, functions, and so on. The menu that pops up differs depending on the type of object. Tables and views have features such as view, edit, Rename, Drop, Query data, and edit data. View and edit are the structure information for viewing and modifying tables, such as fields, primary keys, indexes, constraints, and so on. Query data is equivalent to opening a new window and executing the SELECT * from table. Edit data is equivalent to opening a new window and executing the SELECT * from table for update. Stored procedures and functions have the test function and can be checked to enter the debug state. Sometimes due to PLD recognition error, right-click on the object does not come out the correct menu, can be in the object's DDL or DML statement before, plus a semicolon, so that PLD can correctly determine the type of object

16. TNS Names

Menu Help->support info->tns Names, you can view the Tnsnames.ora of Oracle.

17. Copy to Excel

Execute the SELECT statement in SQL window and, after the result, right-click on the data area below and select Copy to Excel, and you can copy the data area's record to Excel. But there are two points to note: One, field can not start with =, or Excel will be mistaken for function, second, the number should not exceed 17 bits, otherwise the number of digits will be set to 0, but can be by the number in front of ' to make Excel think that field is text, At the same time for the Numbe type of field in the database, it is best to use to_char output, otherwise it may show abnormal

18. Keep the last open SQL script

When you re-enter PL/SQL developer, the Window list can open the document that was last exited:
1) tick the menu tools->window list option;
2) Tools->perferences->user interface->options to the right, "Autosave desktop" is selected.
3) Exit PL/SQL Developer re-enter.

19. Quickly find tables or other objects with known table names

In the Tools menu, tick the object Browser to open the objects browser,
Double-click the folder where an object in the Object Browser is located,
For example, the table is in the Tables folder,
Then enter the name of the table as quickly as possible to find the object starting with a few letters you entered.

20. Quickly close the document window that opens in Windows list easy to use!

Hold down the SHIFT key and left-click the document window you want to close.
My settings are CTRL + left mouse button

22. A simple way to copy Row Records in PL/SQL developer

(1) Click the black triangle to the left of the row record you want to copy, and the row is selected and right-copied.
(2) Paste into Notepad, then copy the content you just pasted. (This step is somehow not missing)
(3) Click the small black triangle on the left side of the new record and paste right.

23. Display the full path of the file in the window title bar

I don't know, what do you mean?
Tools->preferences->user interface->options
Tick "Show Complete file path in Windows titles"

24, double-click to display the table data is important!

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, Object Browser, on the right, bind double-click and drag-and-drop operations for different Object type.

25. SQL window is not careful. Tool-> SQL Windows26, new shortcut key 26.a Sort button Edit, selection, sort

The selected row can be sorted by the first character size (point two is reversed), the effect of the following sort before: Click on the positive order: and then click Reverse:

26.b go to the end of the space 26.C display special characters these two functions together with a good 1) to go to the end of the space: Edit, Selection, Remove tailing blanks general out of the script before the end of the line to delete all the better, to maintain good coding habits , guaranteed not to be a moth. 2) display spaces and line breaks: edit-Show special characters

Results at a glance

Plsql Developer 11 Usage tips (continuous update)