CREATE STATIC LIST OF VALUES IN ORACLE APEX

In this post, I describe how to create a static list of values from scratch step by step. I hope it will be helpful for beginners Oracle Apex developer .

shared components

Click on Shared Components icon.

list-of-values

Under User Interface, select Lists OF Values and click on Create

click create button

Accept the default, From Scratch and click Next

list of values from scratch

For Name and Type

Name - Task_category [You provide your LOV name here]
Type Select Static

Click Next

create list of values

Enter display values and Return Values. Click on Create List of Values

This message will be appears: "Static list of values created."

static list of values created

If you have any questions, please do not hesitate to post your comments.

cheers !!!!

Comments

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run ALTER PLUGGABLE DATABASE ALL OPEN command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System). Basically Its’s occurring on windows platform.

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working. I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why it's not working ???

Solve Your Every Day Technical Problem

Search This Blog