Performing DML Operations on XML Schema Based XMLType Views

Author: exforsys.com | Published: 23rd May 2008 | Visited: 247 times | Add Comment
Filed in: Programming

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 practice is that the empSch_v view can be inherently updated, so you can perform DML operations against it without having to write INSTEAD-OF triggers.

Read Article

Sponsored Links

• Advancing from Ajax Based Frameworks Frameworks have been in focus lately because of the integration of jQuery to Microsoft. Because of jQuery’ s feat and also of Microsoft frameworks were largely talked about again and compared. Unfortunately there are times wherein a developer would stand up and say the framework is better ...

• Ajax Based Websites in Wii Wii is the family favorite game console because of its simplicity, revolutionary user interaction and a highly competitive price. If PS3 and XBOX360 will lower their prices like that of Wii, Sony and Microsoft would be bankrupt. Wii has apparently caught everyone’s attention and their pock ...

• 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 ...

• .NET Role-Based Security in a Production Environment Edit web.config to Update the Data Provider for Shared Hosting with Role-Based Security: SQL Server, ODBC, Active Directory, ADAM, SQLite, MySQL, Access, ...

• Schema Generator Utility to generate schema description from existing SQL Server data ...

• 2D Vector Class Wrapper SSE Optimized for Math Operations The article demonstrates a 2D vector wrapper, optimized with SSE intrinsics, for math operations with floating point precis ...

• Taking a Fireworks comp to a CSS-based layout in Dreamweaver ? Part 1: Initial design Create your web design in Fireworks before moving it to Dreamwea ...

• A Web based application configuration wizard A wizard that allows you to FTP the application to a remote server and then launch the configuration wizard from the web browser to update the database connect ...

• A simplified non topic based Event Notification Server in wcf with multiple protocol support. To be notified when an alert is generated in a system without filtering for what type of event you are registe ...

• UTF16 to UTF8 to UTF16 simple CString based conversion Use CString to convert betwen UTF8 and U ...

Next: Using Oracle XML DB Repository