[ADMIN] การสร้าง Oracle APEX Application

[ADMIN] การสร้าง Oracle APEX Application

1. Changes in Release 24.2 for Oracle APEX App Builder User’s Guide

2. Quick Start

2.1 About Accessing Your Development Environment

2.2 Understanding Oracle APEX

2.3 Understanding the Workspace Home Page

2.4 APEX Menu Bar

2.5 Understanding App Builder

2.6 Changing Your Profile or Password

2.7 Editing User Preferences and Enabling Dark Mode

2.8 Using Oracle APEX Documentation

2.9 Using the App Gallery

3. App Builder Concepts

3.1 Understanding Applications

3.2 Running an Application or Page

3.3 How Does Page Processing and Page Rendering Work?

3.4 About Enabling Support for Bookmarks

3.5 How Oracle APEX Uses Templates

3.6 Understanding Session State Management

3.7 Managing Session State

3.8 Understanding URL Syntax

3.9 Managing Session State Values

3.10 Using Substitution Strings

3.11 Using Template Directives

4. Managing Team Development

4.1 Getting Started with Team Development

4.2 Creating and Updating Issues

4.3 Viewing Your User Profile

4.4 Managing Labels

4.5 Managing Milestones

4.6 Managing Templates

4.7 Using Team Development Utilities

4.8 Managing Feedback

5. Creating Applications

5.1 Choosing an Application Creation Method

5.2 Using the Simple Create Application Wizard

5.3 Using the Full Create Application Wizard

5.4 Creating an App Using Generative AI

5.5 Creating an Application from a File

5.6 Integrating APEX with Fusion Applications

5.7 Using Application Blueprints

5.8 Copying an Application

5.9 Creating a Working Copy to Merge, Refresh, or Compare

5.10 Creating Applications for Mobile Devices

5.11 Deleting an Application

5.12 Managing Application Attributes

5.13 Managing Application Logos

5.14 Managing Application Icons

5.15 Adding Developer Comments

5.16 Using the Find Icon

5.17 Adding Application Comments

5.18 Managing Application Groups

5.19 Using Application Utilities

5.20 Using Workspace Utilities

6. Managing Pages in an Application

6.1 Adding a New Page to an Application

6.2 About Copying Application Pages

6.3 Creating a New Page by Copying

6.4 Understanding Page Types in the Create Page Wizard

6.5 Managing Feature Pages

6.6 Creating Dialog Pages

6.7 About Deleting Application Pages

6.8 Managing Page Groups

6.9 Locking and Unlocking a Page

7. Editing Pages in Page Designer

7.1 About Page Designer

7.2 Understanding Page Designer UI Elements

7.3 Using Page Designer

7.4 Managing Page Attributes

7.5 Running a Page from Page Designer

7.6 Runtime Developer Toolbar

7.7 Deleting Pages

8. Developing Reports

8.1 Understanding Report Page Types

8.2 Creating a Report Using the Create Application Wizard

8.3 Creating a Report Using the Create Page Wizard

8.4 Creating a Report by Dragging and Dropping from the Gallery

8.5 Managing Cards

8.6 Managing Smart Filters

8.7 Managing Faceted Search

8.8 Managing Interactive Grids

8.9 Managing Interactive Reports

8.10 Managing Classic Reports

8.11 Managing Sorting with Order By Item

8.12 Printing Report Regions

8.13 Understanding BLOB Support in Forms and Reports

9. Developing Forms

9.1 Understanding Form Types

9.2 Creating a Form

9.3 Configuring Lost Update Detection

9.4 About Making an Interactive Grid Editable

9.5 Creating Master Detail Forms

9.6 Validating User Input in Forms

9.7 Understanding BLOB Support in Forms

10. Managing Application Components

10.1 Understanding Oracle JET Integration with Oracle APEX

10.2 Creating Calendars

10.3 Creating Charts

10.4 Creating Maps

10.5 Creating Help for Your Application

11. Using Themes and Theme Styles

11.1 Using Themes

11.2 Managing Themes and Subscriptions

11.3 Creating Custom Themes

11.4 Using Custom Cascading Style Sheets

12. Controlling Page Layout

12.1 About Page Layout in Oracle APEX

12.2 Optimizing a Page for Printing

12.3 Creating a Global Page to Display Components on Every Page

12.4 Managing Regions

12.5 About Incorporating Content from Other Websites

12.6 About Managing Images

12.7 Rendering HTML Using Custom PL/SQL

13. Managing Application Controls

13.1 Managing Page Items

13.2 Managing Dynamic Actions

13.3 Managing Buttons

13.4 Managing Trees

13.5 About Incorporating JavaScript into an Application

14. Adding Navigation

14.1 About Using Lists as Navigation

14.2 Controlling Navigation Using Branches

14.3 Creating Breadcrumbs

14.4 Managing Tabs

14.5 Managing a Classic Navigation Bar

15. Managing Computations, Validations, and Processes

15.1 Understanding Page Computations

15.2 Understanding Validations

15.3 Understanding Page Processes

15.4 Understanding Application Processes

15.5 About Branches

15.6 Understanding Application Computations

15.7 Using the Attribute Dictionary

16. Managing Shared Components

16.1 Accessing the Shared Components Page

16.2 Shared Components Page

16.3 Using Shared Component Subscriptions

16.4 Managing Application Settings

16.5 Managing Application Items

16.6 Managing Component Settings

16.7 Creating Lists of Values at the Application-Level

16.8 Creating Lists

16.9 Adding Search to an Application

16.10 Using Shortcuts

16.11 Using Component Groups

16.12 Managing Email Templates

16.13 Managing Static Application Files

16.14 Managing Static Workspace Files

16.15 Printing a Report Region by Defining a Report Query

16.16 Formatting a Report Region or Report Query Using Report Layouts

17. Upgrading Oracle APEX Applications

18. Managing Application Data

18.1 Creating Applications with Data Loading Capability

18.2 About Using Collections

18.3 Working with Duality Views and JSON Sources

18.4 Managing REST Data Sources

18.5 Managing REST Enabled SQL References

18.6 Managing Remote Servers

18.7 Managing Web Credentials

18.8 Managing Generative Al in APEX

18.9 Accessing Data with Database Links

19. Extending Application Capabilities

19.1 Sending Email from an Application

19.2 Implementing Plug-ins

19.3 Understanding jQuery Support

19.4 Manually Refreshing Oracle APEX Components

19.5 Managing Automations

20. Managing Workflows and Tasks

20.1 About Workflows

20.2 Creating a Workflow

20.3 Copying a Workflow

20.4 Creating the Workflow Console, Workflow Details, and Workflow Dashboard Pages

20.5 Managing Workflow Versions

20.6 About Using Workflows in Page Processes

20.7 Viewing the Workflow Instance ID in Debug Messages

20.8 About Workflow Reports

20.9 Workflow Instance Retention

20.10 Workflow Substitution Strings

20.11 Workflow Views

20.12 About Workflow Keyboard Shortcuts

20.13 Frequently Asked Questions

20.14 About Tasks

20.15 Managing Tasks

20.16 Creating Tasks from Task Definitions

20.17 About Creating Human Tasks Programmatically

20.18 About Creating a Task Definition Process Plug-in

20.19 About Task Retention and Task Purging

20.20 Substitution Strings and Bind Variables for Tasks

20.21 Runtime Views for Tasks

20.22 Troubleshooting Tasks

21. Managing Application Security

21.1 Understanding Administrator Security Best Practices

21.2 Understanding Developer Security Best Practices

21.3 Controlling Access to Applications, Pages, and Page Components

21.4 Establishing User Identity Through Authentication

21.5 Providing Security Through Authorization

22. Managing Application Globalization

22.1 Understanding Application Translation and Globalization Support

22.2 Specifying the Primary Language for an Application

22.3 Applying Format Masks to Items

22.4 About Translating Applications for Multibyte Languages

22.5 Understanding the Translation Process

22.6 Translating Default Reports for Interactive Reports and Interactive Grids

22.7 Translating Messages

22.8 Translating Data That Supports List of Values

22.9 Understanding Supported Globalization Codes

23. Managing Application Performance

23.1 About Best Practices to Improve Performance

23.2 Identifying Performance Issues

23.3 Utilizing Logs and Reports

23.4 About Utilizing Database Reporting

23.5 About Database Parameters that Impact Performance

23.6 About Limiting Resources

23.7 About Uploading Static Files to Your Web Server

23.8 Creating Custom Activity Reports Using APEX_ACTIVITY_LOG

24. Debugging an Application

24.1 Reviewing Session State

24.2 Utilizing Debug Mode

24.3 Removing Controls and Components to Isolate a Problem

24.4 About Monitoring Application and Page Resource

24.5 Enabling SQL Tracing and Using TKPROF

24.6 Running Advisor to Check Application Integrity

25. Deploying an Application

25.1 System Development Life Cycle Methodologies to Consider

25.2 Understanding the Deployment Process

25.3 Exporting and Importing from App Builder

25.4 How to Create a Custom Application

25.5 About Publishing an Application URL

25.6 Using Build Options to Control Configuration

25.7 Understanding One-Click Remote Application Deployment

26. Managing Application Legacy Components

26.1 Legacy Forms Optimized for Mobile Environments

26.2 Viewing Legacy Components in the Gallery

26.3 Managing Legacy Calendars

26.4 Managing Applications with Legacy Data Loading Capability

26.5 Managing Legacy Tabular Forms

26.6 Managing Legacy Web Services

A About Item Types

B Oracle APEX Limits

C Directory Structure When Splitting Export Files into Separate Scripts

D Correlating APEX Sessions to Database Sessions

E Available Conditions

F About Granted Privileges

 


    • Related Articles

    • [ADMIN] การดูแลระบบ Oracle APEX

      1. Changes in Release 24.2 for Oracle APEX Administration Guide 2. Workspace and Application Administration 2.1 Understanding Workspace Administration 2.2 Using the Manage Service Page 2.3 Making a Service Request 2.4 Configuring Workspace ...
    • [ADMIN] การสร้าง User บน Apex

      การสร้าง User บน Apex รายละเอียดขั้นตอนการสร้าง User บน Apex มีดังนี้ ขั้นตอน ขั้นตอนการทำงาน 1 เข้าไปที่ https://prodpaaskku.lanna.co.th/ เลือก Oracle APEX ล็อคอินด้วย Administration Services 2 สร้าง Account ไปที่ Create User กรอกรายละเอียด Account ...
    • [ADMIN] การเริ่มต้นใช้งานบน Oracle Cloud Infrastructure

      1. การลงชื่อเข้าใช้งานบน Oracle Cloud Infrastructure 1.1 ผู้ดูแลระบบสามารถเข้าใช้งาน Oracle Cloud Infrastructure ผ่านทาง URL ดังต่อไปนี้ https://cloud.oracle.com จะปรากฏหน้าจอดัง รูป 1 รูป 1 หน้าจอการลงชื่อเข้างาน Oracle Cloud Infrastructure 1.2 ...
    • [ADMIN] แนวทางและวิธีการสร้างการเชื่อมต่อ บน Oracle Integration Cloud

      1. แนวทางและวิธีการสร้างการเชื่อมต่อ (Integration) บน Oracle Integration Cloud (OIC) แนวทางและวิธีการสำหรับการสร้างการเชื่อมต่อ (Integration) บน Oracle Integration Cloud (OIC) โดยเน้นที่การสร้าง API และการใช้ Connectivity Agent ...
    • [ADMIN] คู่มือการเชื่อมต่อ Oracle Cloud Applications

      คู่มือการเชื่อมต่อ Oracle Cloud Applications Oracle Fusion Cloud Applications Suite REST API for Common Features in Oracle Fusion Cloud Applications SOAP Web Services for Common Features 1 Enterprise Resource Planning (ERP) 1.1 Procurement · REST API ...