PL/SQL developer skills

1. PL/SQL developer remember the login password. When PL/SQL developer is used, PL/SQL developer wants to remember the login username and password for Oracle for ease of work. Setting method: PL/SQL developer 7.1.2-> Tools-> preferences-> Oracle-> logon history. The "store history" option 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 the F8 key. By default, PL/SQL developer executes all SQL statements in the window, the SQL statement where the mouse is located, that is, the current SQL statement is executed. Setting Method: PL/SQL developer 7.1.2 --> Tools-> preferences --> window types, check "Autoselect statement. 3. When formatting an SQL statement using the SQL window of PL/SQL developer, sometimes the entered SQL statement is too long or too messy, and you may want to use a more common format, this will look better and better for analysis. Usage: select the SQL statement to be formatted, and then click the PL/SQL beautifier button on the toolbar. 4. Check the execution plan when using the SQL window of PL/SQL developer, 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, click the explain Plan button on the toolbar (that is, the execution plan), or press F5 directly. 5. When you use PL/SQL developer to operate Oracle, you can call stored procedures or debug stored procedures. To call stored procedures, first, select procedures in the browser on the left of PL/SQL developer to find the stored procedure to be called. Then, right-click the stored procedure to be debugged and choose test, in the displayed test SCR limit PT window, for a parameter defined as in type, you need to enter a value for the parameter value. Finally, click the number button above: start debugger or press F9. Click RUN or Ctrl + R.