In the IDE

The database diagram now includes the offline database view:

database diagram

You can use the Edit View dialog to edit other clauses of the view, such as GROUP_BY and ORDER_BY. To specify that the SQL statement for the view uses CREATE or CREATE OR REPLACE, use the DDL page of the Edit View dialog. This page can also be used to review the complete SQL for the view.

Edit View dialog