Oracle Apex - Update Button on a query

Posted on 2012-08-21
Last Modified: 2012-08-22
Hello Experts,

I have a query that selects

3 columns,

the last column has been changed to a TEXT area so that I can edit data in that column

I want to have a button that will submit those changes to the table.

can someone point me in the right direction
Question by:futureDBA
    1 Comment
    LVL 6

    Accepted Solution

    Have you setup the query as a Tabular Form? This allows you to update the data in a table within APEX. Add a Submit button and it will save the changes. The application will prompt the you about changes when you use the pagination links on the report as well.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now