PL / SQL Developer Basic Understanding (Transfer) Transfer from 9CBS PL / SQL Developer Basic Uses Detailed Detailed Detailed Details (recommended to read the first stored process) Oracle complained, in order to stabilize it provides the graphical operation speed Slowly sad, P4 128M machine can make people sad, and then operate in DBA Studio is really crying. PL / SQL Developer is solving this problem: powerful, convenient, fast. After using it, it is absolutely inseparable! Its main strength is as follows: 1. Edit table data (nature of the browsing table data is naturally not in the words) I have a little upset when writing a long statement under SQL PLUS, and it is available here. Third. Write the stored procedure and debug. If there is no SQL / Plus dev, I don't know how to debug hundreds of stored procedures. It is said that this effect is not too much ten times. Hereinafter, specifically described: one. The browsing window on the left selection tables will list all the tables, select the table right Mogout Menu "Edit Data", and there will be a new window to list all the data of the table. There is a tool bar above the table, and the icons are "lock", "add ( )", "delete (-)", "save (hook)". How do you submit a modification after modifying the data? 1. Click "Hook" to save the data. 2. Look at the second column of the toolbar, there are two good stuff, icon is not easy to describe, let's put the mouse on these two button icons, will display "Commit (F10)", "Rollback (SHIFT F10 ). CommIT will be submitted to the data, point it. OK? ^ _ ^ DBA Studio does not seem to paste the copy data, here I want to copy ^ _ ^ ^ 2. New -> Command Window -> It is equivalent to SQL PLUS, which is of course better than SQL Plus. three. Function Description Function User: Q & D and Differential: GetSumAndSub (P1 in Number, P2 in Number, M Out Number, B Out Number) Parameters: M = P1 P2 B = P1-P2 1. First Storage Process Left The browsing window Select Procedures, list all stored procedures, right-click Folder Procedures Click Menu "New", pop up the Template Wizard window, enter GetSumAndSub in the name box, P1 In Number, P2 in Number, M Out Number, B Out Number. Click OK to create a code window for the stored procedure. The content is the statement that creates a stored procedure. Enter specific content between BeGin End, finally the following; Create or Replace Procedure getSumAndSub (P1 in Number, P2 in Number, M Out Number, B Out Number) IS Begin M: = P1 P2; B: = P1-P2; End getSumndsub; click the "Save" button to save the SQL statement of the created stored procedure in the file, and use ^ _ ^ to do this is to do this SQL statement to create a stored procedure.
