Oracle updating through view
SELECT COLUMN_NAME, UPDATABLE FROM USER_UPDATABLE_COLUMNS WHERE TABLE_NAME = 'EMP_DEPT'; COLUMN_NAME UPD ------------------------------ --- EMPNO YES ENAME YES DEPTNO YES SAL YES DNAME NO LOC NO 6 rows selected.
statement lets you locate recompilation errors before run time.
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.
If you are using a release of My SQL 5.1, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release.
If you are using a release of My SQL 5.1, see this document for licensing information, including licensing information relating to third-party software that may be included in this Community release. This product may include third-party software, used under license.
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.
For details and more information, see the My SQL section of the Lifetime Support Policy for Oracle Technology Products ( If you have any questions about the features included in your edition of My SQL 5.1, refer to your My SQL 5.1 license agreement or contact your Oracle sales representative.For notes detailing the changes in each release, see the My SQL 5.1 Release Notes. For help with using My SQL, please visit either the My SQL Forums or My SQL Mailing Lists, where you can discuss your issues with other My SQL users.For additional documentation on My SQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the My SQL Documentation Library. This product may include third-party software, used under license.Note: It is not necessary that the key or keys of a table be selected for it to be key preserved.
It is sufficient that if the key or keys were selected, then they would also be keys of the result of the join.
When a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a column list.