Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Insert/Update/Delete operation from Apex 24.1 form

AR KappilFeb 13 2025

@inol

Hi Dears,

Is it possible to Insert, Update, and Delete data in a table using a single form in APEX 24.1? I created a form based on a table, and I can insert data into the table by clicking the default ‘Create’ button. However, I want to retrieve an existing record from the table if the given field data (primary key field) already exists. If it does, the data should be displayed in the form, allowing the user to edit or delete it. If the record does not exist, the form should be treated as a new entry, allowing the user to enter values for the given columns. In Oracle Forms, a single form is sufficient for all DML operations. How can I achieve this in APEX 24.1? Should I create two separate forms—one for inserting data and another for modifying or deleting records? Thank you for your support and guidance.

Best Regards,

AR

This post has been answered by PetarSimic on Feb 13 2025
Jump to Answer

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Feb 13 2025
7 comments
115 views