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

    How to display blob image in html css report oracle apex?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on August 20, 2021 at 1:22 pm

    okay. Give it a try to this one: Declare c_img clob; Begin c_img := apex_web_service.blob2clobbase64(h); <img src="data:image/jpg;base64, '|| c_img ||'"/> End;

    okay. Give it a try to this one:

    Declare
      c_img clob;
    Begin
      c_img := apex_web_service.blob2clobbase64(h);
      <img src="data:image/jpg;base64,
         '|| c_img ||'"/>
    End;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: August 11, 2021

    How to setup email in oracle apex

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Replied to answer on August 13, 2021 at 1:47 pm

    Yes, I think so.

    Yes, I think so.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: August 10, 2021

    How to give page under maintenance message on specific apex page

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on August 10, 2021 at 1:59 pm

    To show the page under maintenace message, follow these steps: Create a blank page and create a region inside and give the title "Page is under maintenance.". Create a table app_settings as below: Create Table app_settings (dev_mode varchar2(1) default 'N'); Insert a row as below: Insert into app_seRead more

    To show the page under maintenace message, follow these steps:

    • Create a blank page and create a region inside and give the title "Page is under maintenance.".
    • Create a table app_settings as below:
    Create Table app_settings (dev_mode varchar2(1) default 'N');
    • Insert a row as below:
    Insert into app_settings (dev_mode) values ('Y');
    Commit;
    • Now open your page no. 2, and in Pre-rendering > Before Header > Create a Branch to redirect to the page you created in the first step and specify the serverside condition Rows Returned and add the below query:
    select 1 from app_settings where nvl(dev_mode, 'N') = 'Y'

    This will do the job.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: June 18, 2021

    How to collapse right column on page load

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on June 18, 2021 at 8:11 am

    On page load, create a dynamic action to execute JavaScript code and add the following code in it: jQuery("#t_Button_rightControlButton").click(); If the button id is not correct then you will have to inspect your right column button to get the correct id.

    On page load, create a dynamic action to execute JavaScript code and add the following code in it:

    jQuery("#t_Button_rightControlButton").click();

    If the button id is not correct then you will have to inspect your right column button to get the correct id.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: June 12, 2021

    How can we compare the checkbox page item(multiple selection) in where clause

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on June 12, 2021 at 3:17 pm

    Do not change anything in the below cursor. Use as-is: Cursor C1    is    select EMPCD,EMPNAME,LSTSAL,ESEX,EMRTSTS,EDESGN from empmst where    EDESGN in (SELECT t.column_value FROM table (Apex_String.Split(:P9944_EDESGN,':')) t WHERE t.column_value IS NOT NULL); In the above query, "table" and "coluRead more

    Do not change anything in the below cursor. Use as-is:

    Cursor C1
       is
       select EMPCD,EMPNAME,LSTSAL,ESEX,EMRTSTS,EDESGN from empmst where
       EDESGN in (SELECT t.column_value
    FROM table (Apex_String.Split(:P9944_EDESGN,':')) t
    WHERE t.column_value IS NOT NULL);

    In the above query, "table" and "column_value" are the keywords, so do not change them.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: June 11, 2021

    2 Buttons or more in one column classic report

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on June 12, 2021 at 5:47 am

    Ok, we are very near 😃 Again modified: SELECT ROWID, '<a class="t-Button t-Button--noLabel t-Button--icon t-Button--tiny t-Button--success t-Button--simple" href="javascript:setItem('||chr(39)||rowidtochar(ROWID)||chr(39)||');"'||'>btn-1</a>' <br>' .. your next button AS BTNS

    Ok, we are very near 😃

    Again modified:

    SELECT ROWID,
    '<a class="t-Button t-Button--noLabel t-Button--icon t-Button--tiny 
    t-Button--success t-Button--simple"
    href="javascript:setItem('||chr(39)||rowidtochar(ROWID)||chr(39)||');"'||'>btn-1</a>' <br>'
    .. your next button AS BTNS
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: May 14, 2021

    CSS Styling of Apex Objects to make larger Buttons or Input boxes

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on May 16, 2021 at 6:29 am

    Yes, the custom attribute is the shortcut 😀. And I tried increasing the size of icons, but it was not happening. So you can use the image instead of the icon. To do this, upload small images for buttons in the Shared Components > static files. Then you can use it in your CSS. Just add one more CSRead more

    Yes, the custom attribute is the shortcut 😀.

    And I tried increasing the size of icons, but it was not happening.

    So you can use the image instead of the icon. To do this, upload small images for buttons in the Shared Components > static files.

    Then you can use it in your CSS. Just add one more CSS to your style attribute as below:

    background-image: url(#APP_IMAGES#yes.jpg);
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: May 6, 2021

    Create column in interactive report to redirect to corresponding page

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on May 7, 2021 at 7:27 am
    This answer was edited.

    Usage of elsif with the case is wrong. Below is the right syntax: case when nvl(STATUS,'APPROVED')='APPROVED' then 'f?p=&APP_ID.:100:8:&APP_SESSION.:::8:P8_ID:'||ID when nvl(STATUS,'REQUESTED')='REQUESTED' then 'f?p=&APP_ID.:100:9:&APP_SESSION.:::9:P9_ID:'||ID else '#' end LINKRead more

    Usage of elsif with the case is wrong. Below is the right syntax:

    case when nvl(STATUS,'APPROVED')='APPROVED' then
     'f?p=&APP_ID.:100:8:&APP_SESSION.:::8:P8_ID:'||ID
     when nvl(STATUS,'REQUESTED')='REQUESTED' then
     'f?p=&APP_ID.:100:9:&APP_SESSION.:::9:P9_ID:'||ID
    else
     '#'
    end LINK

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: April 28, 2021

    APEX: How can I refer a row in a report - Server-side conditions

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on April 28, 2021 at 3:55 pm

    Server-side condition is not for this purpose. To show the name instead of the id, you need to put the join in your report query. Below is an example: Select a.people_Id, p.name from yourReportTable a, people p where a.people_id = p.id; Then hide the people_id column from the report and show the namRead more

    Server-side condition is not for this purpose.

    To show the name instead of the id, you need to put the join in your report query. Below is an example:

    Select a.people_Id, p.name from yourReportTable a, people p
      where a.people_id = p.id;

    Then hide the people_id column from the report and show the name column.

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: April 22, 2021

    Temporarily store and retrieve data

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on April 22, 2021 at 4:21 pm

    I think you can store the data temporarily in the tables, and if there is no consent or the user presses the cancel button, you can silently delete using the dynamic action to execute server-side code.

    I think you can store the data temporarily in the tables, and if there is no consent or the user presses the cancel button, you can silently delete using the dynamic action to execute server-side code.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 7

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