GeekArticles 
FAQ Oracle FAQupdatable views
Author: asktom.oracle.com |
Published: 10th May 2008 |
Visited: 80 times |
Add CommentFiled in: Oracle FAQHi Tom,
I'm facing a problem with updateable views and instead of triggers.
I've to deal with a "big" table, more than 300 columns and hundred thousands
of records.
I would like to replace this table with a view and splitting the "big"
ta...
Read Article Sponsored Links
Related Articles
• Using XMLType Views Using XMLType Views
Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML. Once written, an XMLType view may be used in various queries, making them simpler and so increasing their readabili ...
• Performing DML Operations on XML Schema Based XMLType Views Performing DML Operations on XML Schema-Based XMLType Views
Analyzing the underlying query of the empSch_v view discussed in the preceding section, you may note that each attribute of the EMP_T object used in the select list maps to a certain column of a single table, namely emps. What this means in ...
• Using XMLType Views Using XMLType Views
Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML. Once written, an XMLType view may be used in various queries, making them simpler and so increasing their readability.
...
• Performing DML Operations on XML Schema Based XMLType Views Performing DML Operations on XML Schema-Based XMLType Views
Analyzing the underlying query of the empSch_v view discussed in the preceding section, you may note that each attribute of the EMP_T object used in the select list maps to a certain column of a single table, namely emps. What this means...
