Sign Up

❇️ 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.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: May 20, 2021

    Display Interactive Report for different roles sql query

    afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    Added an answer on May 22, 2021 at 12:19 pm

    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)

    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)

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: May 17, 2021

    Create Row Button to update table and set value of page item

    afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    Added an answer on May 18, 2021 at 8:59 am

    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');

    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');

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: February 21, 2021

    How to create time duration item in Oracle APEX?

    afzal

    afzal

    • India
    • 1 Question
    • 50 Answers
    • 3 Best Answers
    • 319 Points
    View Profile
    afzal Guru
    Added an answer on February 23, 2021 at 3:41 pm

    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

    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
    from dual CONNECT BY LEVEL<97;

    NOTE- Format Mask===>DD/MM/YYYY HH:MI AM

    STEP 2-- CREATE SECOND ITEM "P115_END_TIME" AS SELECT LIST

    QUERY--
    select TO_CHAR(TO_DATE(:P115_START_TIME,'DD/MM/YYYY HH:MI AM') + (1/1440*(level-1)*15),'HH:MI AM')||
    CASE WHEN (((level-1)*15))/60 >1 THEN
    CASE WHEN MOD(((level-1)*15),60)> 0 THEN '( '|| FLOOR((((level-1)*15))/60)||' HOURS '|| MOD(((level-1)*15),60)||' MINUTES )'
    ELSE '( '||(((level-1)*15))/60||' HOURS)'
    END
    ELSE
    CASE WHEN ((level-1)*15)=0 THEN '( 0 MINUTES )'
    ELSE
    CASE WHEN MOD(((level-1)*15),60) = 0 THEN '( 1 HOURS )'
    ELSE '( '||MOD(((level-1)*15),60)||' MINUTES )'
    END
    END
    END AS DD ,
    ((level-1)*15) RR //--RETURN VALUE AS YOUR REQUIREMENT

    from dual CONNECT BY LEVEL<97

    Cascading List of Values --
    PARENT ITEM-- P115_START_TIME

    See less
    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us