PL/SQL Developer tips, pldeveloper

PL/SQL Developer tips, pldeveloper

1. PL/SQLDeveloper remembers Login Password

 

   When PL/SQL is usedFor the convenience of work, PL/SQLDeveloper remembers the username and password used to log on to Oracle;

 

Setting Method: PL/SQLDeveloper 7.1.2 -> Tools-> Preferences-> Oracle-> Logon History. "Store history" is selected by default. Just check "Store with password, remember to enter the password once you log on again.

 2. Enable Automatic capital of keywords

Setting Method:> tools-> Preferences --> user interface --> editor --> keyword case is selected as uppercase
  3. copy the query result to excel.
Run the Select statement in the SQL Window. After the result is displayed, right-click the data area below and Select Copy to Excel to Copy the records in the data area to the Excel file. But there are two points to note: first, the field cannot start with =; otherwise, Excel will mistakenly think of it as a function; second, the number should not exceed 17 digits; otherwise, the subsequent digits will be set to 0, however, you can add 'to the front of the number to make Excel think that the field is text. At the same time, it is best to use to_char to output Numbe fields in the database. Otherwise, it may be abnormal.
  4. Automatic completion
Setting Method:> tools-> Preferences --> user interface --> editor On the right interface, the AutoReplace and Edit buttons can be written as follows:
S = SELECT * FROM
Save it.

 

5. Execute a single SQL statement

 

   When PL/SQL is usedDeveloper SQLWindow, press F8, PL/SQLBy default, Developer executes all SQL statements in the window. You need to set the SQL statement where the mouse is located to execute the current SQL statement;

 

Setting Method: PL/SQLDeveloper 7.1.2 --> tools-> Preferences --> Window types, just check "AutoSelect Statement.

 

 

 

6. Format SQL statements

 

   When PL/SQL is usedDeveloper SQLWindow, sometimes the entered SQL statement is too long or too messy, and you may want to use a more general syntax, which looks better and better for analysis;

 

Usage: select the SQL statement to be formatted, and click PL/SQL In the toolbar.Beautifier button.

 

 

 

7. view the execution plan

 

   When PL/SQL is usedDeveloper SQLWindow, sometimes the efficiency of the input SQL statement execution, analysis of the table structure, how to improve the query efficiency, you can view the execution plan provided by Oracle;

 

Usage: select the SQL statement to be analyzed, and click Explain in the toolbar.Plan button (Execution plan), or press F5 directly.

 

 

 

8. debug the Stored Procedure

 

   When PL/SQL is usedDeveloper sometimes calls some stored procedures or debugs stored procedures when operating Oracle;

 

Method for calling a stored procedure: first, in the PL/SQLSelect Procedures in the Browser on the left of Developer to find the stored procedure to be called. Then, right-click the stored procedure to be debugged and select Test. In the displayed Test scr history pt window, for a parameter defined as in, you need to enter a Value for the parameter Value. Finally, click the number button above: Start debugger or press F9. Finally, click RUN or Ctrl + R.

How to Use pl/SQL developer?

Create a new file in the upper left corner. There are many options in it. If you are querying a table, select the SQL window and then enter the query statement in the window.

Pl SQL developer usage Problems

In the SQL window, write the SQL statement. Select the prepared SQL statement and click the gear icon on the toolbar to execute the SQL statement or press F8 to execute it, in addition, after executing the INSERT, UPDATE, or DELETE statement F8, You need to COMMIT it (green down arrow icon or F10 key). You can also set automatic submission, but we do not recommend automatic submission, regret is too late;
COMMAND is a COMMAND line mode that can also be used to write SQL statements. It is rarely used here. You can CREATE a table structure or index or other CREATE statements here, you can also execute prepared SQL files in batches;
Other windows are rarely used, and most of them can be completed using SQL windows. It's a great tool and a must-have tool for developers.