Digvijaysinh Virpura's Blog

This post demonstrate the steps to display image based on the column value in the table with Interactive Report in Oracle APEX. Simple Report:   Instead of Patient Risk value we need to get as shown below Steps: 1    I have created a table as shown below.       CREATE TABLE "DEMO_PATIENT"       (            "PATIENT_ID" NUMBER(5,0) NOT NULL ENABLE,         "PATIENT_NAME" VARCHAR2(50) NOT NULL ENABLE,         "PATIENT_RISK" VARCHAR2(10) NOT NULL ENABLE,    CONSTRAINT "DEMO_PATIENT_PK" PRIMARY KEY ("PATIENT_ID")ENABLE        )     / In Above table Patient_Risk column can contain only two possible values. 1. High  2. Low  So based on these values we will show images. Step2:  Create a Report in your APEX Application   ...

There are some cases where user forget the password of admin account of Oracle Application Express Account. Step1: Go to Command Prompt Step2: Connect to Sysdba account of oracle database Step3:   Execute following query select username from dba_users where username like 'APEX%' order by 1;  As i have APEX 19.1 installed it show the versions.  Step4: Now you need to switch to APEX_SCHEMA which required resetting of password SQL> alter session set current_Schema = APEX_190100 Step5: Unlock your admin account with following code.  begin       wwv_flow_security.g_security_group_id := 10;       wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');      commit; end;