Press "Enter" to skip to content

Oracle Apex 19.2: Create Star Rating Page Item (New Feature)

In Oracle Apex 19.2, a new type of page item is introduced is Star Rating with this new feature you can add an option to rate anything. It will store the numeric value in the database table and will display the stars on the page. In this tutorial, you will learn how to create a Star Rating page item in Oracle Apex 19.2.

Steps to Create a Star Rating Page Item in Oracle Apex 19.2

1. Add a field in the table to store star rating value as shown in the below example:

  Alter table employees add star_rating number;

2. Now in Oracle Apex page designer, add a page item or do the right-click on existing Form region and select Synchronize Page Items so that newly added field can appear automatically. Then set its type to Star Rating and set the following properties as shown below:

Oracle Apex default star rating setting.

It is done now. Save the changes and run the form. You will have the output as shown in the below screenshot:

Oracle Apex star rating field output.

Here you can click the stars to rate and after saving the changes it will store the rating value, for example, for the above-selected stars it will store 4 in the field Star_Rating in the Employees table.

Customize The Star Rating Page Item in Oracle Apex

You can customize the number of stars to display, the color of the stars, show a clear button and more. To do this, turn off the Use Defaults button and set the properties as shown in the below image:

Oracle Apex - Customize star rating page item.


Oracle Apex star rating customised look.

Related Tutorials:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community for developers and ask your question. It is FREE.

Vinish Kapoor


Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

1 Comment
Newest Most Voted
Inline Feedbacks
View all comments
5 months ago

Thanks, it works great

I am looking for a solution that would change color depending on the value, for example the shape of a circle, 1 is red, 2 is blue, 3 is green, etc.

is this possible?