PL/SQL Developer use

One: daily use to the menu

File menu: New, Open, Save.

Edit menu: Code formatting, find-and-replace, copy-paste, and so on.

Session Menu: Log in and log out, execute SQL statement.

Tools menu: Configuration, Window tab, and so on.

Second: Interface Common window, icon

1: Connection window: Record some of the actions of this connection

2: Browse window: From here you can choose to browse the files of the user database, including: Defined objects, packages, stored procedures, functions, tables, and so on. Right-click the popup menu to view, edit, Test.

3: Window list: You can toggle the open window from here

4:sql window: The most common window. You can open a SQL window to retrieve data from some tables in the database, create stored procedures, and so on.

5: Debug window: For debugging stored procedures, functions.

6: Most commonly used toolbar icons:

Code beautification, indenting and canceling indents, quick commenting, or canceling comments

New, open

Log in and out, fast Execution (F8)

Three: Shortcut key and use skill

1: Fast Execution--f8

2: Execute a single statement--mouse cursor resting place F8

3: Execute multiple statements--select more than one statement F8

4: Beautify code--toolbar PL/SQL Beautifier

5: Debug Stored Procedure-Select procedures in the Browse window to find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, in the test Scrīpt window that is defined as the in type parameter, 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; Last click: Run or Ctrl+r.

--Debugging shortcut keys
Toggle Breakpoint: Ctrl+b
Start: F9
Run: Ctrl+r
Single Step Into: Ctrl + N
Step Skip: Ctrl+o
Single Step exit: Ctrl+t
Run to Exception: Ctrl+y

6: Set automatic prompt--tools->preferences->user Interface->code assistant->automatically activated

7: Set auto complement--tools->preferences->user Interface->key configuration

8: Set code hint template--tools->preferences->edit->autoreplace so that when the template name is entered, auto-complete is the template content.

9: Keyword capitalization--tools->preferences->editor, keyword case selected uppercase.

PL/SQL Developer use