PL/SQL Developer managing multiple sets of databases

PL/SQL Developer manages multiple sets of databases and connects multiple sets of databases as a unified interface platform.

1..

1, class SQL Plus Windows: File->new->command window, this is similar to Oracle's client tool SQL Plus, but it is much more useful.

2, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. This is easy to read code, and to maintain a good coding style, in the same way, in Tools->preferences->code Assistant (assistant) can set the code hint delay time, enter a few characters when prompted, the database object uppercase, lowercase, First letter capitalization, etc.;

3. Review the Execution plan: Select the SQL statement you want to analyze, then click the Explain Plan button on the toolbar (i.e. execution plan), or press F5 directly; this is mainly used to analyze the efficiency of SQL statement execution, analyze the structure of the table, so as to provide a visual basis for SQL tuning;

4, Automatic replacement: Fast input SQL statements, such as input s, press the 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–>editor–>autoreplace (auto-replace) –>edit

1), create a text file Shortcuts.txt, and write the following: S=select copy code is saved to PL/SQL Developer installation path under ~/plugins directory 2), tools–>preferences– >user Interface–>editor–>autoreplace, select the Enable check box, and then browse the file to select the Shortcuts.txt that you created earlier, click Apply. 3), restart PL/SQL Developer, enter the s+ space in the windows, sc+ space to do the test. Note: Shortcuts.txt cannot be removed, otherwise shortcut keys will not work

The following defines some rules as reference I=insert u=update s=select f=from w=where o=order by D=delete Df=delete from Sf=select * from Sc=select COUN T (*) from Sfu=select * from for UPDATE cor=create OR REPLACE p=procedure fn=function t=tigger v=view sso=set serveroutput On;

Set shortcut keys (Setup method: Menu tools–>preferences–> user interface –> key configuration) New SQL window: ctrl+shift+s new command window: ctrl+shift+c new test window: ctrl+shift+t PL/SQL Developer: Ctrl+shift+f Redo: ctrl+shift+z undo: Ctrl + Z clear: ctrl+d (use with caution, not recoverable, I am disabled Oh O (∩_∩) o~) Check all: Ctrl + a indent: tab Cancel indent: Shift+tab uppercase: Ctrl+shift+x lowercase: ctrl+shift+y Note: ctrl+h uncomment: ctrl+m find: ctrl+f display table structure: CTRL + hover over the table name on the template list: Shift+alt+r Window list: ctrl+w

5. Execute a single SQL statement: Press the F8 key

6, TNS Names: Menu Help->support info (support information)->tns Names, you can view the Tnsnames.ora of Oracle;

7. Debug stored procedures when using PL/SQL developer to operate Oracle, some stored procedures are sometimes called, or stored procedures are debugged; methods for calling stored procedures: 1), first, in PL/SQL Developer Select Procedures in the left browser to find the stored procedure that needs to be called, 2), then, select the stored procedure for debugging, right-click, select Test, in the Test Scrīpt window of the pop-up, for the parameter defined in type, You need to enter values for the value of this parameter, and finally click the number of bars button above: Start debugger or press F9; 3), Last click: RUN or Ctrl+r.

Debug shortcut key Toggle Breakpoint: Ctrl+b Start: F9 run: Ctrl+r Step into: CTRL + N Single Step skip: Ctrl+o Single Step exit: Ctrl+t Run to Exception: Ctrl+y

8. Template shortcut keys

9. 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, will open the Brower Folders Order window, the "My Objects" set as the default. Tools menu –>brower Folders The few directories you regularly order (e.g. Tables views Seq Functions Procedures) Move up a bit and color-coded so that your average look-up time will be much shorter and try.

Priority, left-to-right tables–>tablespaces–>procedures–>users–>roles

2..

PL/SQL Developer is an Oracle-based database commonly used to edit and debug software, and PL-SQL developer focuses on ease of use, code quality and productivity, giving full play to the main advantages of Oracle application development, and is loved by more and more people. So how do we write SQL statements quickly in the process of using PL-SQL developer, the following describes a feature of this software: auto-replace

Baidu Experience: jingyan.baidu.com

Tools/Materials

• Oracle Database
• PL/SQL Developer

Baidu Experience: jingyan.baidu.com

Method/Step

2. 1

   With the Oracle database and PL/SQL developer installed, we present the Chinese version of PL/SQL developer.

   Steps to read
4. 2

   After installation, open PL/SQL developer, select Tools-Preferences; English version is tools--preferences

   steps to read steps to read
6. 3

   In the pop-up Preferences dialog, select: User Interface--editor--Auto-replace (autoreplace), allow the grid to select the check box, then turn on the auto-replace function.

   Steps to read
8. 4

   Click the Edit button below to eject the auto-replace definition edit box. You can choose the replacement content in the box according to your own typing habit. such as S=select * from, de=delete from, Al=alter table and so on.

   Steps to read
10. 5

    Click Save, then the system defaults to save as a "AutoReplace.txt" document, select the appropriate folder path.

    Steps to read
12. 6

    Of course, if you already have a ready to replace the definition of the document, you can also directly select the corresponding definition document, under the Auto-replace column, choose to find the corresponding path of the document can be very convenient, such as: X:\11\AutoReplace

    Steps to read
14. 7

    After saving, we create a new SQL window to test: If you define the S=select * from, you can enter a "S", and then press the SPACEBAR to see if it is directly replaced with a select * from, very convenient, suitable for the regular writing of SQL script children's shoes to speed up the writing speed, Get off work soon, haha

PL/SQL Developer managing multiple sets of databases