Display Product Rating Icons Dynamically in APEX Report
Display Product Rating Icons Dynamically in Oracle APEX Report Display Product Rating Icons Dynamically in Oracle APEX Report 1. CREATE TABLE - PRODUCT_RATING..... CREATE TABLE "PRODUCT_RATING"
( "OID" NUMBER,
"PRODUCT_ID" NUMBER,
"PRODUCT_CODE" VARCHAR2(250),
"PRODUCT_NAME" VARCHAR2(250),
"START_DATE" DATE,
"PRODUCT_RATING" VARCHAR2(50)
)
/ 2. Create a function GET_PRODUCT_RATING. CREATE OR REPLACE FUNCTION GET_PRODUCT_RATING (p_value IN NUMBER)
RETURN VARCHAR2
IS
l_return VARCHAR2 (4000);
l_checked VARCHAR2 (240)
:= ' ';
l_un_checked VARCHAR2 (240)
:= ' ';
l_max_value NUMBER := 5;
l_remaining NUMBER;
BEGIN
IF p_value BETWEEN 1 AND 5
THEN -- Check given values are in the range
l_remaining := l_max_value - p_value;
/* Add checked user ratings */
FOR i IN 1 .. p_value
…
