![apex sql command editor apex sql command editor](https://filedb.experts-exchange.com/incoming/2015/12_w51/1054921/8.png)
We also see another button beside that called " Find Tables", once clicked on it we will see another window which helps us to search any table name from our database and check the details of the columns and its types.
![apex sql command editor apex sql command editor](https://www.sqlshack.com/wp-content/uploads/2017/09/word-image-170.png)
![apex sql command editor apex sql command editor](https://blog.mclaughlinsoftware.com/wp-content/uploads/2018/08/APEX_INSTANCE_ADMIN.png)
APEX SQL COMMAND EDITOR CODE
Form the above screen shot we can see that we have executed on PLSQL block now let us see what will happen when we click on the "Clear Command" button.įrom the above screen we can see that only the top section is cleared where we have written our PLSLQ code to execute but the result remains the same unless the next SQL or PLSQL statements are executed. In the top section of the SQL commands tool we can see there is button called "Clear Command", to clear the screen of the top section this option is used. The below screen shot shows an example like how we can execute SQL and PLSQL statements on the top sections and see the result in the bottom sections. The tool is basically divided into two sections, in the top section we can type any SQL queries or PLSQL block and the bottom section is the place where we get the results of SQL/PLSQL block. The above screen shot provide the details on where we can write our SQL or PLSQL statements and how we can execute it. Once you select the option as shown in above screen shot we will see the below screen which is called as "SQL Command Tool". This is the place where we can select and write any SQL statements or any PLSQL code to execute and check the output. Now you can see under "SQL workshop" we have an option to select "SQL Commands". In general we can utilize this tool like how we use SQL Developer tool to query or manipulate the database objects.Ĭlick on "SQL Workshop" as shown in above screen shot. But in object browser we cannot execute the simple SQL statements that we can use here. For example creating any database objects or manipulating it. We can use most of the actions using SQL command tool that we have seen using APEX object browser. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database objects which can later be used in our application. It helps us to make changes on the database directly using a graphical user interface. The SQL Command Tool comes with APEX under SQL Workshop.