Application Express User's Guide > Building Queries with Query... > Working with Saved Queries > Saving a Query
Saving a Query |
Previous |
Next |
To save a query:
Build a query:
On the Database Home Page, click the SQL icon.
Click the Query Builder icon.
Select objects from the Object Selection pane.
Add objects to the Design pane and select columns.
Execute the query.
Click Save.
Enter a name and description and click Save.
The saved query displays in the Saved SQL view.
Note that Query Builder does not support duplicate query names. If you open an existing query, keep the existing name, and save it again, Query Builder over-writes the existing query. If you change the name of an existing query and save it again,Query Builder saves the query again under the new name.