Oracle updating through a view Free phone line chat dominant women

Posted by / 30-Apr-2019 06:53

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

oracle updating through a view-87oracle updating through a view-56oracle updating through a view-52

Usually, to do this would require multiple insert, update, and delete statements for each table in the join.

One thought on “oracle updating through a view”