Some uses of Plsql developer

1Pl/SQL Developer Remember login password when using PL/SQL developer when it's convenient to work hopefully PL/SQL Developer Remember to log in to Oracle user name and password; Setup method: PL/SQL Developer7.1.2   -Tools -Preferences -Oracle -The "Store History" is checked by default, and the "store withpassword "Can, re-login at the time of entering the password is remembered. 2, execute a single SQL statement using PL/SQL Developer SQL window, press the F8 key, PL/SQL developer defaults to all SQL statements that execute the window and needs to be set to the SQL statement where the mouse is located, executing the current SQL statement; setting method: PL/SQL Developer7.1.2 -->tools->preferences-->window types, hook on "AutoSelect Statement" can. 3, formatted SQL statements using PL/SQL Developer SQL window, sometimes the input SQL statement is too long or too messy, I hope to use a more general format words, so look good, or analysis; How to: Select the SQL statement that you want to format, and then click Pl on the toolbar /SQL beautifier button.4, viewing the execution plan using PL/SQL Developer SQL window, sometimes input SQL statement execution efficiency, analysis of the following table structure, how to improve the efficiency of the query, you can view the execution plan provided by Oracle; How to: Select the SQL statement you want to parse, Then click the Explain Plan button on the toolbar (i.e. execution plan), or press F5 directly. 5, the debug stored procedure uses the PL/when SQL Developer operations Oracle, some stored procedures are sometimes called, or stored procedures are debugged, and methods of calling stored procedures: first, the PL/In SQL Developer, select Procedures in the left browser to find the stored procedure that needs to be called, then select the stored procedure for debugging, right-click, select Test, and in the Test Scrīpt window, for the parameter defined in type You need to enter a value for this parameter's value; Last click the number of bars button above: Start debugger or press F9; Last click: RUN or CTRL+R. 6, autoSelect &AutoExecuteTools -Preferences -SQL Window, select both Autoexecute queries and AutoSelect statement. As soon as this feature is enabled, by pressing F8 (corresponding to the "execute" shortcut), you can execute the SQL statement where the cursor is located, instead of using the mouse to select the statement you want to execute first. 7, keyword Auto-capitalization tools -Preferences -Editor, select the keyword case uppercase. The keyword is usually capitalized, other such as table name, field name, etc. are lowercase. Everyone should develop a coding habit of their own and keep it going. 8, change the default Execute shortcut key F8 to Ctrl+enter (similar to toad) Tools -Preferences -KeyConfiguration -Session/Execute, and then press CTRL+Enter. 9, save login Password Tools -Preferences -Logon history -Choose the Store withPassword. Ten, Autoreplace Auto-replace function Tools -Preferences -Editor -Autoreplace -Select the enabled and edit file to add the following: SF=Select *  fromSCF=Select Count(*) froms=SelectF= fromW=whereD=Deleteu=Update--End--[/size]

Some uses of Plsql developer