Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then you are going to love this place.

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

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Swarup/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: November 2, 2020

    Showing information on IR Region

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 3, 2020 at 11:18 am

    thnx for you support how to get data from db in place of hello eg:Total Hours: (it is calculating dynamically )

    thnx for you support how to get data from db in place of hello

    eg:Total Hours: (it is calculating dynamically )

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: November 3, 2020

    Inserting App user into the data table in Oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 3, 2020 at 10:52 am

    Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data Eg: If RAM has entered the data then the manager can view that the ram has entered it in the user field. if Shyam has entered tRead more

    Sir if manager login to approve the tasks for different member then in the app_user will get manager name but i want to get the name of the person who have entered the data

    Eg:

    If RAM has entered the data then the manager can view that the ram has entered it in the user field.

    if Shyam has entered the data then the manager can view that the Shyam has entered it in the user field.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: November 2, 2020

    Showing information on IR Region

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Added an answer on November 3, 2020 at 9:54 am

    Can it be possible to design this

    Can it be possible to design this

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: November 3, 2020

    Inserting App user into the data table in Oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 3, 2020 at 9:53 am

    Thnx sir it works

    Thnx sir it works

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 8:31 pm

    Thanx so much sir for your kind support

    Thanx so much sir for your kind support

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 6:56 pm

    When i am trying to do multiple row update i am getting folowing error

    When i am trying to do multiple row update i am getting folowing error

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 5:59 pm

    if :p3_statusall = 'Approve All' then Update times set statusm = case when statusm is null then 'APPROVED' else statusm end; set statust = case when statust is null then 'APPROVED' else statust end; Where pid = :p3_pid; apex_util.set_session_state('P3_STATUSM', 'Approved'); elsif :p3_statusall = 'ReRead more

    if :p3_statusall = ‘Approve All’ then
    Update times
    set statusm = case when statusm is null then ‘APPROVED’ else statusm end;
    set statust = case when statust is null then ‘APPROVED’ else statust end;

    Where pid = :p3_pid;
    apex_util.set_session_state(‘P3_STATUSM’, ‘Approved’);

    elsif :p3_statusall = ‘Reject All’ then
    Update times
    set statusm = case when statusm is null then ‘REJECTED’ else statusm end;
    set statust = case when statust is null then ‘REJECTED’ else statust end;
    Where pid = :p3_pid;
    apex_util.set_session_state(‘P3_STATUSM’, ‘Rejected’);

    end if;

     

     

    i have multiple fileds to be set approve i.e., 5 days a week(statusm,statust,statusw …) will this plsql work

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 5:39 pm

    yes it is and am not getting P3_Statusm Valued as Approved in front end but in db it is getting stored

    yes it is and am not getting P3_Statusm Valued as Approved in front end but in db it is getting stored

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 5:35 pm

    Yes Refresh->Region

    Yes Refresh->Region

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 27 Questions
    • 116 Answers
    • 0 Best Answers
    • 185 Points
    View Profile
    Swarup Professional
    Replied to answer on November 2, 2020 at 5:25 pm
    This answer was edited.

      Same as previous not firing   apex_util.set_session_state('P3_STATUSM', 'Approved'); this is not working but the status field is changing

     

    Same as previous not firing

     

    apex_util.set_session_state('P3_STATUSM', 'Approved');  this is not working but the status field is changing 
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 12

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • Bheem

    What is best way to design school time table?

    • 0 Answers
  • OrclQA Wiki

    How to display file contents in MAC terminal app?

    • 1 Answer
  • Greg

    Displaying image in modal window

    • 3 Answers
  • Greg Grimes

    20.2 APEX: How can I pre-select the searchable column in ...

    • 0 Answers
  • Vinish
    Vinish added an answer Yes, this is also fine. January 19, 2021 at 3:25 pm
  • Greg
    Greg added an answer I tried your solution and it worked, but since I… January 19, 2021 at 3:23 pm
  • Vinish
    Vinish added an answer You can use the cat command to display file contents… January 19, 2021 at 10:41 am
  • Vinish
    Vinish added an answer You need to apply some CSS. Follow the below steps:… January 19, 2021 at 9:31 am
  • Timo Herwix
    Timo Herwix added an answer What is about the standard read- only Attribute? read more… January 17, 2021 at 4:59 pm

Recent Blog Posts

  • Vinish

    Copy URL to Clipboard on Button Click Examples

  • Vinish

    Find When Your Mac Was Last Shutdown

  • Vinish

    Oracle SELECT Statement

  • Vinish

    Python Append List to List Example

  • Vinish

    JavaScript Object Get Value by Key

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2020 OrclQA.Com. All Rights Reserved. Privacy Policy