Home/ Questions/Q 211
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-08-09T23:21:29+00:00

How can I update a field in another table using a form in Oracle Apex?

  • 1
  • 1

Figure 1

Figure 2

Figure 3

 

Hi guys! I would like to ask is it possible to update a field in another table using a form in Oracle? So my situation is like this: This is an equipment borrowing system. I have created a report and a form for my first table Record (figure 1 and 2), which saves the record of people borrowing the equipment. At the same time, what I wanted to do is when an equipment is being borrowed away, the availability will change from ‘Y’ to ‘N’ (figure 3) , and all these will happen when I click the ‘Apply Change’ button in Figure 2. May I ask if it is possible to do so? thankyou so much as this homework is super important for me!!

oraclequestion
Share
Leave an answer

Leave an answer

Browse

2 Answers

  1. Hi Cilenhy,

    Yes, it is possible to do, follow these few easy steps:

    In the form you shown in figure 2, click on the process tab, there you will find a few processes. Now create one more process as PL/SQL code type and write your update statement there. For example:

    Update equipment_table
   set availability = 'N'
 where equipment_id = :P2_YourFormPageItem;
Commit;

    That is all but note create this process before the close dialog process of your form page.

    You can find the full tutorial in my following blog post: How to Create a PL/SQL Code Process in Oracle Apex?.

    Please let me know if still any issues. Thanks.