Do you know how pl/sql developer runs sql statements? Some of you may not know it yet, so now I will share with you how pl/sql developer runs sql statements. You can take a look.
1. First open the software, enter the user name, password and select the database server configured in the computer on the login page of the software, and then click the "OK" button in the lower left corner of the login page to enter the main interface of the software.
2. Then find the "File" option in the upper left corner of the main interface of the software. Click this option and a drop-down box will appear. We select "New" in the drop-down box and click "SQL Window" in the sub-drop-down box that appears.
3. A SQL window will pop up on the interface. We can enter the SQL statement to be executed in the window according to our own needs.
4. Then find the gear button in the upper left corner of the interface. You can click this button to execute the SQL statement; you can also click the F8 key on the keyboard to execute the SQL statement.
5. Then, a result window will appear on the interface, in which you can view the results of the SQL statement execution, edit these results, and export the excel table.
6. Finally, we can also find the "Query Designer" button at the top of the interface. Click this button and a query designer window will appear, in which you can quickly query table properties.
The above is the method of running sql statements by pl/sql developer shared by the editor. I hope it can help everyone.