Oracle forms updating a view

Regards, Joe Bautista What is the version of your database?

Want to learn about the latest developer technologies and practices, directly from Oracle and Community technology experts? Select the sessions that interest you most and attend from anywhere using your PC, laptop or tablet.

In this guide, the Oracle Forms application is first analyzed for its components, and then a similar analysis of the Visual Basic . Strategies for migrating from Oracle Forms to Visual Basic . A detailed discussion on how to perform the migration is beyond the scope of this guide.

The goal of this chapter is to provide a blueprint for performing the migration.

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from Tech Target experts.

Introduction and Goals Migration Approach Examining Oracle Forms Understanding Visual Basic . Oracle Forms-based applications can retrieve and manipulate data in Oracle databases. It is not possible to modify an Oracle Forms application for interoperation with a Microsoft® SQL Server™ database, and it is recommended that applications of this type are rewritten. NET is an ideal choice for rewriting an Oracle Forms application because it is very similar in nature to Oracle Developer, both in terms of the development tools and wizards, as well as the end product itself.

Once upon a time, a long time ago, I thought triggers were the coolest thing ever and I used (and abused) them heavily.

Now, whenever possible, I will go very far out of my way to avoid a trigger.

You can create a view to be inherently updatable, or you can create an INSTEAD OF trigger on any view to make it updatable.