Save to database
Select Results--> Save to Database to
save the query results to a table on the database server.
Note:
You can run a query at a database server and save
the query results to a table at a different database server.
The Save Data dialog box opens with three tabbed pages:
- At the General page, identify the database
server, table owner, table name, comment, and table space for the
data being saved
- At the Options page, identify how to save
the data
- Optional: At the ROWIDs page,
specify ROWID information
Note:
This command is available only when you are viewing
query results.
