You can use the SQL Worksheet to enter and execute SQL, PL/SQL and SQL*Plus statements. You can specify any actions that can be processed by the database connection associated with the worksheet, such as creating a table, inserting data, creating and editing a trigger, selecting data from a table, and saving that data to a file.
Make sure that the database in which you are creating the objects supports all your offline database types. For instance if you are using an Oracle XE Database, note that it does not support table partitions. If you choose a database that does not support table partitions and you have been following along with this example, the range partitions for the ORDERS table should be deleted from the script as they cannot be added to an XE database.
In the SQL Worksheet toolbar,
Run Script executes all the statements in the Enter SQL Statement box. To run a specific statement, select the statement and click
Execute Statement. Other toolbar icons allow for operations such as History that displays a dialog with information about SQL statements that you have executed, and Explain Plan that generates the execution plan for the statement.