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: August 10, 2021

    Data Extract in CSV with double quotes

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 Points
    View Profile
    Swarup Professional
    Replied to answer on August 11, 2021 at 6:24 pm

    At query level it's working when we go to procedure level then the data are not getting as expected

    At query level it's working when we go to procedure level then the data are not getting as expected

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: August 10, 2021

    Data Extract in CSV with double quotes

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 Points
    View Profile
    Swarup Professional
    Replied to answer on August 11, 2021 at 3:46 pm

    Hi if we use this then will get the static value whatever is present inside single quotes only that will reflect. I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come

    Hi

    if we use this then will get the static value whatever is present inside single quotes only that will reflect.

    I need data from the oracle database if the user has entered in double-quotes then that double quotes also should come

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

    RTF Template if else Condition

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 Points
    View Profile
    Swarup Professional
    Replied to answer on February 9, 2021 at 12:26 pm

    I am using this statement in RTF template in BIP publisher word docs.

    I am using this statement in RTF template in BIP publisher word docs.

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

    Showing information on IR Region

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  5. Asked: November 3, 2020

    Inserting App user into the data table in Oracle apex

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  6. Asked: November 2, 2020

    Showing information on IR Region

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  7. Asked: November 3, 2020

    Inserting App user into the data table in Oracle apex

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  8. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  9. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
  10. Asked: November 2, 2020

    Approve all dynamically in oracle apex

    Swarup

    Swarup

    • India
    • 31 Questions
    • 119 Answers
    • 0 Best Answers
    • 207 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
1 2 3 … 12

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