❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Display Interactive Report for different roles sql query
afzal
select id,column as title from form f,manager m,users u where f.mid=m.mid and u.id=m.id and where lower(u.username)=lower(:session_user_name) union all select id,column as title from form f,manager m,users u where f.mid=m.manid and u.id=m.id and where lower(u.username)=lower(:session_user_name)
Create Row Button to update table and set value of page item
afzal
I think , you should use 'id' instead of 'mid' at this below code only. JavaScript Expression: $(this.triggeringElement).parent().data('mid') correct-- JavaScript Expression: $(this.triggeringElement).parent().data('id');
How to create time duration item in Oracle APEX?
afzal
STEP 1-- CREATE ITEM "P115_START_TIME" AS SELECT LIST QUERY-- select to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'HH:MI AM') DISPLAY , to_char(TO_DATE('01/01/2021 09:00:00','DD/MM/YYYY HH:MI:SS') + (1/1440*(level-1)*15),'DD/MM/YYYY HH:MI AM') RETURN_VAL fromRead more