How to insert/delete/update data into VIEW using forms 6i

5 pts.
Tags:
Forms 6i
Oracle development
Oracle Forms
i have created a view like create or replace view emp_dept as select emp.empno,emp.ename,dept.deptno,dept.dname from emp,dept where emp.deptno=dept.deptno; how to insert/delete/update data into the view emp_dept using forms 6i ?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can insert/delete/update data in a view the same way you do with a table, but remember there are some restrictions when doing these operations on join views (for example: you cannot modify more than one base table, you cannot modify a column which maps to a non key-preserved table, you cannot delete from a view without exactly one key-preserved table, etc…).

You can create “instead of ” triggers for the view and deal with all of the tables in the view.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Brijesh
    Hi,

    The basic SQL database activities are all handled automatically in Forms6i if you create a block based on a table or view.  You can add triggers like:
    1. pre-insert and/or pre-update to provides some values automatically (user ID, timestamp, etc.)
    2. when-validate-item to insure that the value entered exists in a database table somewhere, or meets some other criteria you need to enforce.

    There are many more triggers initiated by various events that can be used for more complex data entry, validation, screen manipulation, etc. but I recommend starting with no (or only a few simple) triggers, then adding additional functionality and/or complexity after you get used to the basics.
    10,185 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following