When you run the SQL script, the output displays in the Script Output page of the SQL Worksheet:
The Database Navigator lets you view and edit database objects directly in your database. Database connections that are owned by the IDE (available to all applications) are displayed under an IDE Connections node. If a connection is owned by an application, it is displayed under a node for the owning application, for example CreateDBObjects. The DBDEMO connection under CreateDBObjects contains the database objects you have just generated.
In the Application Navigator, Application Resources panel, if you expand Database | DBDEMO under Connections, you should also see the database objects you have generated.
Copyright © 1997, 2009, Oracle. All rights reserved.