Application Express User's Guide > Managing Database Objects w... > Managing Views > Creating a View
Creating a View |
Previous |
Next |
To create a new view:
On the Database Home Page, click the Object Browser icon.
Object Browser appears.
Click Create.
From the list of object types, select View.
Define the view:
View Name - Enter a name for the View.
Query - Specify a query to define the view.
To access Query Builder or SQL Command Processor, click the appropriate link at the bottom of the page. The selected tool appears in a pop-up window. Once you create the appropriate SQL, click Return to automatically close the popup window and return to the wizard with the SQL.
Click Next.
A confirmation page appears. To view the SQL used to create the view, click SQL.
Click Create.