APEX

Hi,

1. I have table as student_info and pmeta_data

student_info                                                      

stud_id   name     class                                      

1             abc           1

2             xyz            1

3             mno           2

2. select class as 1,it will give  popup message as " Number of students are 2 for this particular class"  and  click on update button,it will  update from  class 1 to class 2 and for particular class and it will store in pmeta_data table in single row

student_info                                                  pmeta_data                                                     

stud_id   name     class                                class      stdu_id    promotion_date                                    

1             abc           2                                      1          1:2            04/04/2017

2             xyz            2

3             mno          2

3.Again if i select class 2 then it will give popup message as" Number of students are 3 for this particular class" . So i want to get the count of students for class 2 as 1 using javascript after updating.

Kindly help me.

Using    APEX 5.0

             Oracle 11g

Thanks.