Selecting Multiple Records using LOV in Oracle APEX | List of Values | LOV | Oracle APEX | SQL

 Selecting Multiple Records using LOV in Oracle APEX

     Step-1: 

        Create Blank page.

     Step-2: 

        Create region type Static content.

     Step-3: 

         Create Page item and select the type is POPUP LOV

 

                 Write the query for list of values.

    SQL Query:

     SELECT Test_id FROM xxgt_test;

 Step-4:

 

         Create buttons Search and Clear

 

 

 

          Create process for clear button. 

                Identification: Type - CLEAR SESSION STATE

                When button press:  Clear

 

Step-5:  

         Create region and type is interactive report.

 

      SQL query:-

 

        SELECT TEST_ID,

                   TEST_NAME,

                   STATUS,

                   POINTS

     FROM XXGT_TEST

    WHERE (instr(':'|| :P2_test_id || ':',':'|| TEST_ID ||':') > 0 OR :P2_test_id is null);

 

Step-6: 

     Save and run the page.

Output:

 

                Select the Ids and click on search button.