PL/SQL Developer Usage tips (partial)
- Keyword Auto capitalization
- What if you want keywords to be automatically capitalized when you enter SQL statements in the SQL command window?
- One-step setup can be achieved. Click Tools->preference->editor, see in this keyword case, the general default is unchanged, select Uppercase in the dropdown box.
- Set auto-replace
- This fast is a big kill, is not sometimes see others only hit two or three keys, the compiler appears a bunch of code, very cool, and this function is not difficult to set up, on the top of the keyword case below, find this autoreplace, the default inside is no file, This requires ourselves to find an insurance position on the computer, create a new AutoReplace.txt file, and add the following code inside:
- SF = SELECT * FROM
SS = SELECT * from e where and order by GROUP by
- After this is set, click Apply->sava, then restart PL/SQL Developer, try knocking "SF plus space" in the compiler, and "select * from" comes straight out.
- Debugging Stored Procedures
- No need to debug stored procedures in writing stored procedures
- Ways to debug stored procedures:
- First, select procedures in the browser to the left of PL/SQL and enter the name of the process you want to debug in the search box
- Then, select the stored procedure, right-click, select Test
- In the pop-up test Script window, for input parameters that are defined as in type, you need to assign a value of one by one to their value first
- Click the number of bars button above
- Start Debugger or press F9 directly
- Finally click Run or ctrl+r;
PL/SQL Developer Usage tips (partial)