Oracle updating through a view Free phone line chat dominant women
) On the i Series, limited support for INSTEAD OF triggers was delivered by PTF SI16101 for i5/OS V5R3 systems. Many PC developer tools–for example, those that come with Visual Studio .
It would be convenient if programmers could simply treat related tables as a single table for the purpose of modifying data.The fields in a view are fields from one or more real tables in the database.You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.With the DB2/400 database embedded in i5/OS V5R4, these modification statements against multi-table views can be accomplished with a special type of trigger called an INSTEAD OF trigger. The biggest benefit I see for this feature is in the client/server realm.INSTEAD OF triggers are special SQL triggers that give the database specific code to run when performing data manipulation (INSERT, UPDATE, and DELETE) against a view. For instance, many third-party, PC-based packages offer simple ODBC interfaces that can only link to a single table to do data updates.
Usually, to do this would require multiple insert, update, and delete statements for each table in the join.