Oracle APEX新手求助：适配当前版本的简单CRUD项目实现指导

Hey there! I totally get how frustrating it is when you're starting out with Oracle PL/SQL and APEX, especially when your course materials are outdated and don't line up with the current version. Let's walk through building a simple CRUD app step-by-step using the latest APEX features—since you already have your table set up, we're halfway there!

Interactive Grids are APEX's modern, out-of-the-box solution for CRUD operations—they handle most of the code generation for you. Here's how to set one up:

• Navigate to your APEX workspace, go to App Builder, and create a new blank app (keep it simple to avoid extra clutter).
• Once your app is created, click Create Page > Select Interactive Grid > Hit Next.
• For the data source, choose Existing Table and pick the table you created earlier via Object Browser.
• On the next screen, you can customize which columns to include (leave all selected if you want full create/read/update/delete access).
• Name your page something like "Manage [Your Table Name]" and click Create.

After creating the page, click the "Run Page" button in the top right. You’ll see your interactive grid with all the CRUD tools built right in:

• A Create button to add new rows
• Edit icons next to each row to update existing records
• A delete option in the row actions menu to remove entries
  None of this requires writing extra PL/SQL—APEX handles the backend logic automatically!

Since your course uses an older APEX version, here are key changes to note:

• Older versions relied on "Interactive Reports" which were read-only by default—Interactive Grids are the modern replacement that supports inline editing.
• If you want to experiment with manual PL/SQL for CRUD (instead of built-in components), here’s a quick insert procedure example (add this via SQL Workshop > PL/SQL):

CREATE OR REPLACE PROCEDURE insert_my_table (
    p_col1 IN VARCHAR2,
    p_col2 IN NUMBER
) AS
BEGIN
    INSERT INTO your_table_name (col1, col2)
    VALUES (p_col1, p_col2);
    COMMIT;
END;
/

• A basic update procedure would look like this:

CREATE OR REPLACE PROCEDURE update_my_table (
    p_id IN NUMBER,
    p_col1 IN VARCHAR2,
    p_col2 IN NUMBER
) AS
BEGIN
    UPDATE your_table_name
    SET col1 = p_col1, col2 = p_col2
    WHERE id = p_id;
    COMMIT;
END;
/

That said, using APEX’s built-in components is way faster and less error-prone for beginners!

You don’t need external sites—APEX has great context-sensitive help built in:

• When you’re in App Builder, click the Help icon (question mark) in the top right. It pulls up docs tailored to whatever component you’re working on.
• The APEX Learning Library (accessible from your workspace homepage) has free, current beginner tutorials that match the latest version.

If you hit a specific snag—like an error message or a feature that doesn’t behave as expected—share the details, and we can troubleshoot further!

内容的提问来源于stack exchange，提问作者John P