The method of calling stored procedures: 1. When using PL/SQL Developer to operate Oracle, sometimes calling some stored procedures or debugging stored procedures Usage: Select the SQL statement that needs to be analyzed, and then click the Explain plan button in the toolbar (that is, the execution plan), or just press F5.
#Pl Sql Developer 7.1 Serial Number how to
When using the SQL Window of PL/SQL Developer, sometimes the efficiency of the SQL statement execution, Analyze the structure of the following table, how to improve the efficiency of the query, you can view the execution plan provided by Oracle Use: select the SQL statement that needs to be formatted, and then click the PL/SQL beautifier button in the toolbar. This will look better and easier to analyze. I hope to use a more general format to talk about it. When using the SQL Window of PL/SQL Developer, sometimes the SQL statements entered are too long or too messy. Setting method: PL/SQL Developer 7.1.2 ->tools->Preferences->Window types, just check "AutoSelect Statement".
![Pl Sql Developer 7.1 Serial Number Pl Sql Developer 7.1 Serial Number](http://www.ddooo.com/uppic/131222/201312221154112362.jpg)
PL/SQL Developer executes all SQL statements in the window by default, and needs to be set to the SQL statement where the mouse is located, that is, execute the current SQL Statement When using the SQL Window of PL/SQL Developer, press the F8 key.
![Pl Sql Developer 7.1 Serial Number Pl Sql Developer 7.1 Serial Number](https://www.enginatics.com/wp-content/uploads/Dynamic-parameter-SQL-text-example.png)
Setting method: PL/SQL Developer 7.1.2 ->tools-> Preferences->Oracle->Logon History, "Store history" is ticked by default, just check "Store with password", and you will remember when you log in again after entering the password once.
![Pl Sql Developer 7.1 Serial Number Pl Sql Developer 7.1 Serial Number](https://docs.oracle.com/database/sql-developer-18.1/RPTUG/img/GUID-1FE31E46-594A-4CD4-9418-E39932DA5973-default.gif)
When using PL/SQL Developer, for the convenience of work, I hope PL/SQL Developer will remember the user name and password for logging in to Oracle PL/SQL Developer remembers the login password.