Common PL/SQL developer skills

1. PL/SQL developer remember the Login Password
When PL/SQL developer is used, PL/SQL developer needs to remember the username and password for logging on to Oracle for ease of work;

Setting Method: PL/SQL 7.1.2-> Tools-> preferences-> Oracle-> logon history. "store history" is selected by default. Check "store with password, remember to enter the password once you log on again.

2. Execute a single SQL statement
When you use the SQL window of PL/SQL developer, press F8. By default, PL/SQL developer executes all SQL statements in the window and must be set to the SQL statement where the mouse is located, execute the current SQL statement;

Setting Method: PL/SQL 7.1.2 --> Tools-> preferences --> Window Types. Just check "Autoselect statement.

3. Format SQL statements
When PL/SQL developer's SQL window is used, sometimes the entered SQL statements are too long or too messy. If you want to use a common format, it looks better and better for analysis; bad Debt

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

4. view the execution plan
When PL/SQL developer's SQL window is used, sometimes the efficiency of the input SQL statement execution is analyzed to analyze the table structure. You can view the execution plan provided by Oracle to improve the query efficiency;

Usage: select the SQL statement to be analyzed, click the explain Plan button on the toolbar, or press F5.

5. debug the Stored Procedure
When PL/SQL developer is used to operate Oracle, some stored procedures are sometimes called or debugged;

Method for calling a stored procedure: first, select procedures in the browser on the left of PL/SQL developer to find the stored procedure to be called. Then, select the Stored Procedure for debugging and right-click, select test. In the displayed test SCR limit PT window, you need to enter a value for the parameter defined as in. Finally, click the number button above: start debugger or press F9. Click RUN or Ctrl + R. Fashion Java-JavaScript mogujie.com women's clothing