How Do I Use Carousel – Region in Oracle APEX

The Carousel Region in Oracle APEX is a powerful and modern way to present content in a slideshow format. A Carousel allows you to display one item at a time, with navigation controls for moving between items. This is ideal for showcasing featured products, announcements, dashboards, testimonials, images, or any type of card-like data that benefits from focused user attention. With built-in support for media, titles, descriptions, and links, the Carousel Region helps enhance visual storytelling in your APEX applications.

How to Use the Carousel Region in Oracle APEX

Using the Carousel Region involves creating a region, defining the data source, and configuring each slide’s content using declarative settings. Here is a detailed guide:

1. Add a Carousel Region to a Page

   • Open your application in Oracle APEX.

   • Navigate to a page or create a new one.

   • Click + Region and select Carousel from the Reports section.

   • Give the region a name like “Featured Items” or “News Slider”.

2. Define the Data Source

   • Choose a data source: SQL Query or Web Source.

   • Example SQL:

     SELECT product_id,
            product_name,
            product_description,
            product_image_url,
            price
       FROM featured_products
     

   • Ensure your query includes fields for title, description, and image (if needed).

3. Configure Carousel Attributes

   • In Page Designer, under Carousel Attributes, map:

     • Title: product_name

     • Description: product_description

     • Media (Image URL): product_image_url

     • Link: Navigate to product detail page using product_id

   • You can also include:

     • Badge: e.g., “New”, “Limited Offer”

     • Action Button Text: e.g., “Buy Now”

4. Set Display Options

   • Choose Auto Play if you want the carousel to automatically rotate.

   • Configure the interval in milliseconds (e.g., 5000 for 5 seconds).

   • You can enable or disable navigation arrows and pagination dots.

   • Decide whether to loop the slides or stop after the last item.

5. Add Styling (Optional)

   • Use custom CSS in the page or as static files to enhance the look.

   • Example styling for titles or background colors can be applied via class selectors or APEX theme classes.

Examples

Example 1: Product Promotions

• SQL Source: featured_products

• Image: product_image_url

• Title: product_name

• Description: product_description

• Action: link to product details

• Badge: “Sale”

• Auto Play: Enabled

Example 2: Employee of the Month Carousel

• SQL Source: top_employees

• Image: profile_pic

• Title: employee_name

• Description: achievement details

• Badge: month/year

• Link: view full profile

Example 3: News Announcements

• SQL Source: company_news

• Title: headline

• Description: summary

• Media: optional thumbnail image

• Link: full article page

• Auto Play: Disabled (manual navigation)

Best Practices

• Keep slides concise — limit the amount of text shown per slide.

• Use high-quality images — avoid pixelated or stretched media.

• Avoid auto-play for important actions — use manual navigation if user interaction is needed.

• Ensure responsive layout — test the Carousel on various screen sizes.

• Use links wisely — provide direct access to relevant pages through buttons or slide actions.

• Group content logically — only feature the most important or timely content.

In a nut shell, this tool allows the user to “cycle” display through several “regions”. The Carousel Region also allows for the addition of buttons as in any other type of region.

Available Template Options

• Remove Body Padding

• Remember Carousel Slide

• Show Next and Previous Buttons

• Show Maximize Button

• Show Region Icon

Timer	Animation	Body Height	Header	Accent	Style
5 seconds	Fade	Auto - Default	Visible-Default	Default	Remove Border
10 seconds	Slide	240px	Hidden	Accent 1	Stack Region
15 Seconds	Spin	320px	Hidden but accessible	Accent 2
20 Seconds		480px		Accent 3
		640px		Accent 4
				Accent 5

Attributes:

Oracle APEX Documentation

For more information and options, visit the official Oracle APEX documentation:
https://docs.oracle.com/en/database/oracle/apex/
Search for "Carousel Region" to view configuration details and supported attributes.

Conclusion

The Carousel Region in Oracle APEX is an effective way to showcase data in a visually appealing, slide-based format. Whether you're highlighting products, team members, news items, or announcements, the Carousel adds dynamic presentation to your application. With declarative setup, media support, and built-in controls, creating an engaging user experience is simple and efficient. By following best practices and customizing content layout, you can leverage Carousel Regions to drive attention and enhance application usability in Oracle APEX.