Updating view

The column names in an expanded column list are enclosed in quote marks to account for the possibility that the columns of the base object were originally entered with quotes and require them for the query to be syntactically correct.

As an example, assume that the statement, the database can create the view even if the defining query of the view cannot be executed.

Base tables might in turn be actual tables or might be views themselves.

All operations performed on a view actually affect the base table of the view.

This is not such a simple example to start from and this makes things harder to get into.

But it's better to have one example that covers all the points discussed step by step rather than having many different ones that might mix up in mind.

There are only a few differences between a query tree for a entries are set to the current command counter and current transaction ID.

To edit the view, choose it, choose the context (right-click) menu, and then choose Show/edit query.

When a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a column list.

The resulting query is stored in the data dictionary; any subqueries are left intact.

You can use views in almost the same way as tables.

You can query, update, insert into, and delete from views, just as you can standard tables.

Search for updating view:

updating view-84

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating view”